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 )