| A | B |
|---|
| m/d/yyyy | 8/23/2012 |
| d-mmm-yy | 23-Aug-10 |
| d-mmm-yy | 23-Aug |
| mmm-yy | Aug-10 |
| h:mm:ss PM | 10:35:10 PM |
| h:mm:ss AM | 10:35:10 AM |
| h:mm:ss | 22:35:10 |
| h:mm | 22:35 |
| m/d/y h:mm | 8/23/12 22:35 |
| Ctrl+; | Enters a current date in a cell |
| Ctrl+: | Enters a current time in a cell |
| / | Can be used as a date separator |
| - | Can be used as a date separator |
| : | Can be used as a time separator |
| DATE | Returns the serial number of a date |
| DATEDIF | Returns the defference between start_date and end_date |
| DATEVALUE | Converts a date from text to a serial number |
| DAY | Extracts the day componenet from the date given by serial_number |
| DAYS360 | Returns the number of days between start_date and end_date, based on a 360-day year |
| MONTH | Extracts the month component from the date given by serial_number |
| YEARFRAC | Converts the number of days between start_date and end_date into a fraction of a year |
| YEAR | Extracts the year component from the date given by serial_number |
| NETWORKDAYS | Returns the number of whole work days betwen two dates |
| NOW | Returns the serial number of the current date and time |
| EDATE | Returns the serial number of the date that represents the indicated number of months before or after start date |
| EOMONTH | Returns the serial number of the last day of the month before or after a specified number of months |
| TODAY | Returns the serial number of today's date |
| WEEKDAY | Converts a serial number to a day of the week |
| WEEKNUM | Returns the week number in the year |
| WORKDAY | Returns the serial number of the date before or after a specified number of workdays |
