Date Time Functions - Date, Year, Month, Day, Time, Hour, Minute, Second, Today, Now, Datedif
Date
Returns a date, from a user-supplied year, month and day
=DATE(year, month, day)
Year
Returns the year from a user-supplied date
=YEAR(serial_number)
Month
Returns the month from a user-supplied date
=MONTH(serial_number)
Day
Returns the day (of the month) from a user-supplied date
=DAY(serial_number)
Time
Returns a time, from a user-supplied hour, minute and second
=TIME(hour, minute, second)
Hour
Returns the hour part of a user-supplied time
=HOUR(serial_number)
Minute
Returns the minute part of a user-supplied time
=MINUTE(serial_number)
Second
Returns the seconds part of a user-supplied time
=SECOND(serial_number)
Today
Returns today's date
=TODAY()
Now
Returns the current date & time
=NOW()
DatedIf
The Microsoft Excel DATEDIF function returns the difference between two date values, based on the interval specified.
The DATEDIF function is a built-in function in Excel that is categorized as a Date/Time Function. It can be used as a worksheet function (WS) in Excel. As a worksheet function, the DATEDIF function can be entered as part of a formula in a cell of a worksheet.
=DATEDIF(start_date, end_date, return_unit)
Last updated
