Date and time functions

Date and time functions provide a variety of operations on numbers and text strings which enable you to work with dates and times.

Note that the output of many of these functions which you see on screen will have its appearance modified so that it is in the time or date style specified for that cell.

AGE

DATE

DATEVALUE

DAY

DAYNAME

DAYS_360

HOUR

MINUTE

MONTH

MONTHDAYS

MONTHNAME

NOW

SECOND

TIME

TIMEVALUE

TODAY

WEEKDAY

WEEKNUMBER

YEAR

Any times or dates input to all these functions must be supplied in a format which Fireworkz can recognise.

Dates should be entered in the form

day.month.year

where the components are expressed in figures with or without leading zeros. There must be two full stops and no spaces within the date.

If you only give two digits of the year, Fireworkz will use a sliding window to determine the appropriate century.

Times should be entered in the form

hours:minutes{:seconds}

where the components are expressed in figures with or without leading zeros. There must be colons between the figures and no spaces within the time.