ExcelBanter - View Single Post - How can I find out what date going to be 3 month from today in ex

Ron Rosenfeld

On Thu, 8 May 2008 08:44:02 -0700, Shahin Khan <Shahin
wrote:

If today is 08 NOV 2008 after Three or six months later what date going to
be. How can I create a function in MS Excel. Can you please let me know.

My e-mai is
or

Thanks,

Shahin Khan

Both of the other formulas may not give you the answer you wish under certain
circumstances.

For example, given you want an interval of 3 months with

A1: November 30, 2008
Mike H's Formula: March 02, 2009
Susan's Formula: March 01, 2009

If you don't want this variability when the result month has fewer days than
the start month, I would suggest:

=EDATE(A1,3) (If you have the Analysis ToolPak installed or if you have
XL2007).

If not, then:

=MIN(DATE(YEAR(A1),MONTH(A1)+{4,3},DAY(A1)*{0,1}))

Both of those will give a result of February 28, 2009

--ron