Useful Function Codes For Excel
Here are some useful Excel code functions that involve dates and times for your spreadsheets. These codes can be found at the following link http://office.microsoft.com/en-us/excel/HP052042111033.aspx.
Hope they come in handy for you.
Date and Time Functions
|
Function |
Description |
|
Returns the serial number of a particular date |
|
|
Converts a date in the form of text to a serial number |
|
|
Converts a serial number to a day of the month |
|
|
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 |
|
|
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 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 |
|
|
Converts a serial number to a year |
|
|
Returns the year fraction representing the number of whole days between start_date and end_date |
Colleen M. Johnson, CMJ Office
