Returns a date, from a user-supplied year, month and day
=DATE(year, month, day)
Returns the year from a user-supplied date
Returns the month from a user-supplied date
Returns the day (of the month) from a user-supplied date
Returns a time, from a user-supplied hour, minute and second
=TIME(hour, minute, second)
Returns the hour part of a user-supplied time
Returns the minute part of a user-supplied time
Returns the seconds part of a user-supplied time
Returns today's date
Returns the current date & time
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)