| Functions |
What it Does |
| DATE |
Returns the serial number of a
particular date |
|
DATEDIF
|
Calculates the
interval in days, months or years between two dates
|
| DAY |
Converts a serial number to a
day of the month |
| HOUR |
Converts a serial number to an
hour |
| MINUTE |
Converts a serial number to a
minute |
| MONTH |
Converts a serial number to a
month |
| SECOND |
Converts a serial number to a
second |
| TIME |
Returns the serial number of a
particular time |
| TODAY |
Returns the serial number of
today's date |
| YEAR |
Converts a serial number to a
year |
| NOW |
Returns the serial number of the
current date and time |
| WEEKDAY |
Converts a serial number to a
day of the week |
| DATEVALUE |
Converts a date in the form of
text to a serial number |
| 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 |
| NETWORKDAYS |
Returns the number of whole
workdays between two dates |
| TIMEVALUE |
Converts a time in the form of
text to a serial number |
| WEEKNUM |
Converts a serial number to a
number representing where the week falls numerically with a year |
| WORKDAY |
Returns the serial number of the
date before or after a specified number of workdays |
| YEARFRAC |
Returns the year fraction
representing the number of whole days between start_date and end_date |
Back home