Date functions calculate dates and manipulate date information.
System formats affect the way dates are displayed. See Opening files with different system formats.
Click a function name for details.
This function | Returns |
The calendar date for a month, day, and year. | |
A number from 1 to 31, for the day of the month on which a date occurs. | |
Text that is the full name of the weekday for a date. | |
Text in Japanese that is the full name of the weekday for a date. | |
A number representing the day of the week on which a date occurs. | |
The number of days from the beginning of the year of a date. | |
A number from 1 to 12, representing the month of the year in which a date occurs. | |
The full name of the month for a date. | |
The name of the month of a date in Japanese. | |
The number of weeks after January 1 of the year of a date. | |
A number from 1 to 53, representing the week containing a date, from a starting day. | |
A number representing the year in which a date occurs. | |
The Japanese year name of a date, in the specified format. |
•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)