Date & Time Functions
| DATE(year,month,day) | Returns the serial number of a particular date. |
| DATEVALUE(date_text) | Converts a date in the form of text to a serial number. |
| DAY(serial_number) | Converts a serial number to a day of the month. |
| DAYS360(start_date,end_date,method) | Calculates the number of days between two dates based on a 360-day year. |
| HOUR(serial_number) | Converts a serial number to an hour. |
| MINUTE(serial_number) | Converts a serial number to a minute. |
| MONTH(serial_number) | Converts a serial number to a month. |
| NOW( ) | Returns the serial number of the current date and time. |
| SECOND(serial_number) | Converts a serial number to a second. |
| TIME(hour,minute,second) | Returns the serial number of a particular time. |
| TIMEVALUE(time_text) | Converts a time in the form ... |
Get Microsoft Excel X for Mac OS X: Visual QuickStart Guide now with the O’Reilly learning platform.
O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.
