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.
WEEKDAY – returns a integer value representing the day fo the week for a given Excel date and the value is range from 1 to 7.
WORKDAY – returns a serial number that represents a date that is the indicated number of working days before or after the starting date you specified.
WEEKNUM – returns the week number of a specific date, and the returned value is ranging from 1 to 53.
WORKDAY.INTL – returns the serial number of the date before or after a specified number of workdays.
YEAR – returns a four-digit year from a given date value, the year is returned as an integer ranging from 1900 to 9999.
TIMEVALUE – returns the decimal number of the time represented by a text string.
TIME – returned by TIME function is a value between 0 and 0.99988426.
EDATE – returns the serial number that represents the date that is a specified number of months before or after a specified date.