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 |