Tutorial on Excel Date Functions

In this tutorial we will learn the list of date functions and how to effectively utilize the date functions for the purpose conversion of dates to the required format.

Excel DATE Function: Excel DATE Function converts supplied Arguments Year, month and day into an Excel date.

DATEVALUE Function in Excel: DATEVALUE Function in Excel, converts a date in text format to a Serial Number that represent particular date in Excel.

DAYS Function in Excel: DAYS Function in Excel returns the number of days between two dates.

DAYS360 Function in Excel: The DAYS360 function in Excel returns the number of days between two dates based on a 360-day year (12 x 30 months).

EDATE Function in Excel: EDATE Function in Excel returns the date, which is specified number of months before or after the input start date.

DATEDIF Function in Excel: The DATEDIF function in Excel returns the difference between two date values in years, months, or days.

YEAR Function in Excel : YEAR function in Excel returns the four digit year when date is given as an input.

YEARFRAC Function in Excel: YEARFRAC Function in Excel returns the difference between two dates in year as a decimal value

NOW Function in Excel: NOW Function in Excel returns the current date and time.

TODAY Function in Excel: TODAY Function in Excel returns the current date.

Excel TIME Function: Excel TIME Function converts supplied Arguments Hours, Minutes and Seconds into an Excel time.

TIMEVALUE Function in Excel: TIMEVALUE Function in Excel, converts a TIME in text format to a decimal Number

HOUR Function in Excel: HOUR Function in excel returns Hour by taking time as input. Value returned by HOUR Function is number between 0 and 23 as it uses 24 hour format.

MINUTE Function in Excel: MINUTE Function in excel returns Minute by taking time as input. Value returned by MINUTE Function is number between 0 and 59.

SECOND Function in Excel: SECOND Function in excel returns Second by taking time as input. Value returned by SECOND Function is number between 0 and 59.

DAY Function in Excel: DAY function in Excel returns the day part of the date by taking date as input.

MONTH Function in Excel: MONTH function in Excel returns the month part of the date, when date is given as an input.

WEEKDAY Function in Excel: WEEKDAY Function in Excel takes the date as input and returns the day of the week.

WEEKNUM Function in Excel: The WEEKNUM function in Excel takes a date and returns a week number (1-54) that corresponds to the week of year.

ISOWEEKNUM Function in Excel: ISOWEEKNUM function in Excel takes a date as input and returns a week number (1-54).

WORKDAY Function in Excel: The WORKDAY function in Excel takes a date as input and returns the nearest working day in the future or past, based on days value you provide.

WORKDAY.INTL Function in Excel: The WORKDAY.INTL Function in Excel takes a date as input and returns the nearest working day in the future or past, based on days value you provide. It is similar to WORKDAY Function in addition to that WORKDAY.INTL Function allows you to customize which days are considered weekends (non-working days).

NETWORKDAYS Function in Excel: NETWORKDAYS Function in Excel calculates the number of working days between two dates.

NETWORKDAYS.INTL Function in Excel: NETWORKDAYS.INTL Function in Excel calculates the number of working days between two dates. You can also exclude holidays. It is similar to NETWORKDAYS Function in addition to that NETWORKDAYS.INTL Function allows you to customize which days are considered weekends (non-working days).

lets get started towards tutorial on Excel date functions

Tutorial on Excel Date Functions