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 
Returns the calendar date for a month, day, and year. 

Returns a number from 1 to 31, for the day of the month on which a date occurs. 

Returns text that is the full name of the weekday for a date. 

Returns a number representing the day of the week on which a date occurs. 

Returns the number of days from the beginning of the year of a date. 

Returns a number from 1 to 12, representing the month of the year in which a date occurs. 

Returns the full name of the month for a date. 

Returns the number of weeks after January 1 of the year of a date. 

Returns a number from 1 to 53, representing the week containing a date, from a starting day. 

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:
Date ( 6 ; 0 ; 2019 )