Date & Time Functions

Year, Month, Day of a Date  |  Date Add  |  Current Date & Time  |  Hour, Min, Sec

To enter a date in Excel, use the "/" or "-" characters. To enter a time, use the ":" (colon.

Note: Date is in US Format. Months first, Days second. This type of format depends on your windows regional settings.

Dates are stored as numbers in Excel and count the number of days since January 1st, 1900. Times are handled internally as numbers between 0 and 1. To clearly see this, change the number formats to General.

Apparently, 41083 days after January 1st, 1900 is the same as June 23, 2012. 6:00 (quarter through the day) is represented as 0.25.

Year, Month, Day of a Date

To get the year of a date, use the YEAR function.

Note: Use the MONTH and DAY function to get the month and day of a date.

Date Add

To add a number of days to a date, use the following simple formula.

To add a number of years, months and/or days, use the following formula.

Note: the DATE function accepts three arguments: year, month and day.

Current Date & Time

To get the current date and time, use the NOW function (and apply the correct Date format).

Hour, Minute and Second

To return the hour, use the HOUR function.

Note: Use the MINUTE and SECOND function to return the minute and second.

Did you find this information helpful? Show your appreciation, vote for us.

Go to Top: Date & Time Functions    |    Go to Next Topic: Text Functions