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)

​