Date related

[manojk71273]

Hi All

I Have a acceptance date say 28/10/2006 I want to find out the exp date which is after 6 months what formula should I use?

The Information I am having is Acceptance Date & Agreement for No. of Months & the result I want is Last date of that Agreement

Thanks
Manoj

 

[wongm003]

Say you have your date in cells A1... you could use the formula:

=DATE(YEAR(A1),MONTH(A1)+6,DAY(A1))

 

[barry houdini]

If A1 contains 31st August 2006 then the formula

=DATE(YEAR(A1),MONTH(A1)+6,DAY(A1))

will return 3rd March 2007

If you use

=EDATE(A1,6) then this will give 28th February 2007

note: EDATE requires Analysis ToolPak add-in to be enabled