Search

Learn Edate function is used to calculate a date which is a specific number of months in the past or future.

EDATE

Learn Edate Excel Formula

What Does It Do?
This function is used to calculate a date which is a specific number of months in the past or
in the future.

Syntax
=EDATE(StartDate,Months)

Formatting
The result will normally be expressed as a number, this can be formatted to represent
a date by using the Format,Cells,Number,Date command.

Example
This example was used by a company hiring contract staff.
The company needed to know the end date of the employment.
The Start date is entered.
The contract Duration is entered as months.
The =EDATE() function has been used to calculate the end of the contract.

Edate Excel formula Example-1

The company decide not to end contracts on Saturday or Sunday.
The =WEEKDAY() function has been used to identify the actaul weekday number of the end date.
If the week day number is 6 or 7, (Sat or Sun), then 5 is subtracted from the =EDATE() to
ensure the end of contract falls on a Friday.

Edate Excel Formula Learn Example-2
50 =EDATE(C48,D48)-IF(WEEKDAY(EDATE(C48,D48),2)>5,WEEKDAY(EDATE(C48,D48),2)-5,0)
Share this article :
Facebook
Twitter
LinkedIn

Leave a Reply