This section will learn how to use Excel’s Date And Time Functions such as: Date, Datedif, Day, Days, Days360, Hour, Now, Time, Weekday, Year, etc.
DATE – returns the serial number for a date.
DATEDIF – returns the number of days, months, or years between tow dates.
DAY – returns a day of a date (from 1 to 31)
DAYS – returns the number of days between two dates
DAYS360 – calculate the number of days between two dates based on a 360-day year.