To get detailed information about a function, click its name in the first column.
Function |
Description |
---|---|
Returns the serial number of a particular date |
|
Calculates the number of days, months, or years between two dates. This function is useful in formulas where you need to calculate an age. |
|
Converts a date in the form of text to a serial number |
|
Converts a serial number to a day of the month |
|
Returns the number of days between two dates |
|
Calculates the number of days between two dates based on a 360-day year |
|
Returns the serial number of the date that is the indicated number of months before or after the start date |
|
Returns the serial number of the last day of the month before or after a specified number of months |
|
Converts a serial number to an hour |
|
Returns the number of the ISO week number of the year for a given date |
|
Converts a serial number to a minute |
|
Converts a serial number to a month |
|
Returns the number of whole workdays between two dates |
|
Returns the number of whole workdays between two dates using parameters to indicate which and how many days are weekend days |
|
Returns the serial number of the current date and time |
|
Converts a serial number to a second |
|
Returns the serial number of a particular time |
|
Converts a time in the form of text to a serial number |
|
Returns the serial number of today's date |
|
Converts a serial number to a day of the week |
|
Converts a serial number to a number representing where the week falls numerically with a year |
|
Returns the serial number of the date before or after a specified number of workdays |
|
Returns the serial number of the date before or after a specified number of workdays using parameters to indicate which and how many days are weekend days |
|
Converts a serial number to a year |
|
Returns the year fraction representing the number of whole days between start_date and end_date |
Important: The calculated results of formulas and some Excel worksheet functions may differ slightly between a Windows PC using x86 or x86-64 architecture and a Windows RT PC using ARM architecture. Learn more about the differences.