Date & Time Functions
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.
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.
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.
To get the current date and time, use the NOW function (and apply the correct Date format).
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.