Date functions

Date functions calculate dates and manipulate date information.

System formats affect the way dates are displayed. See Opening files with different system formats.

Function	Purpose
Date	Returns the calendar date for a month, day, and year.
Day	Returns a number from 1 to 31, for the day of the month on which a date occurs.
DayName	Returns text that is the full name of the weekday for a date.
DayOfWeek	Returns a number representing the day of the week on which a date occurs.
DayOfYear	Returns the number of days from the beginning of the year of a date.
Month	Returns a number from 1 to 12, representing the month of the year in which a date occurs.
MonthName	Returns the full name of the month for a date.
WeekOfYear	Returns the number of weeks after January 1 of the year of a date.
WeekOfYearFiscal	Returns a number from 1 to 53, representing the week containing a date, from a starting day.
Year	Returns a number representing the year in which a date occurs.

Notes

You can use zero (0) and negative numbers as date function arguments. For example, the following formula returns 5/31/2019:

Copy

Date ( 6 ; 0 ; 2019 )