|
DATE |
Returns the serial number of a particular date |
|
DATEVALUE |
Converts a date in the form of text to a serial number |
|
DAY |
Converts a serial number to a day of the month |
|
DAYS360 |
Calculates the number of days between two dates based on a 360-day year |
|
EDATE |
Returns the serial number of the date that is the indicated number of months before or after the start date |
|
EOMONTH |
Returns the serial number of the last day of the month before or after a specified number of months |
|
HOUR |
Converts a serial number to an hour |
|
MINUTE |
Converts a serial number to a minute |
|
MONTH |
Converts a serial number to a month |
|
NETWORKDAYS |
Returns the number of whole workdays between two dates |
|
NOW |
Returns the serial number of the current date and time |
|
SECOND |
Converts a serial number to a second |
|
TIME |
Returns the serial number of a particular time |
|
TIMEVALUE |
Converts a time in the form of text to a serial number |
|
TODAY |
Returns the serial number of today's date |
|
WEEKDAY |
Converts a serial number to a day of the week |
|
WORKDAY |
Returns the serial number of the date before or after a specified number of workdays |
|
YEAR |
Converts a serial number to a year |
|
YEARFRAC |
Returns the year fraction representing the number of whole days between start_date and end_date |