Excel Date And Time Functions

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.

Leave a Reply