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)

47KB

Date-Time Function.xlsx

Date-Time Formulas Examples