Excel 2010 EDATE function

Excel 2010 provides list of DATE function to calculate date value promptly, as it is a tedious job when going for it manually. EDATE is right function to be used for this sole purpose, it will instantly returns future or past date value as per specified condition.

To begin with, launch Excel 2010 spreadsheet on which you need to apply EDATE function. For instance, we have included spreadsheet containing fields; S.No, Date of Commencement, and Due Date.

Now we will be finding out ending date in Due Date field, for this we will be using EDATE function which will instantly return due date according to specified condition.

The syntax of EDATE function is;


In function, start_date refers to starting date and months refers to number of months for past or future that should be calculated.

We will be writing this function as;


In function arguments, B1 refers to location of cell where starting date is residing and 2 in the function argument represents calculation of date after 2 months.

It will yield future date after two months.

edate result

Drag the plus sign at the end of the column towards the end of column to apply the function over.


If you need to find out date after 4 months from todays’ date. Enter function arguments as;



For finding out some date back in past, just change the sign of month argument in function to negative, it will show you the calculated past date.


past months

You can also check out our previously reviewed Excel functions; MROUND, MODULUS & QUOTIENT, RANK.AVG and RANK.EQ, WORKDAY.INTL, LARGE, CEILING, TIME, ADDRESS ,FACT (factorial), MAX,MIN, MAXA, MINA and EXACT, Logical Functions, INFO, SUMSQ, DOLLAR, SUMPRODUCT, SUMIF, COUNTIF, VLOOKUP, HLOOKUP ,PMT, & LEN.

قالب وردپرس

About Alyse Kalish

Alyse Kalish
As an Associate Editor for The SalesJobInfo, Alyse is proud to prove that yes, English majors can change the world. She calls many places home, including Illinois where she grew up and the small town of Hamilton where she attended Colgate University, but she was born to be a New Yorker. In addition to being an avid writer, Alyse loves to dance, both professionally and while waiting for the subway.

Leave a Reply

Your email address will not be published. Required fields are marked *