How can I find out what date going to be 3 month from today in ex

  • Thread starter Thread starter Shahin Khan
  • Start date Start date
S

Shahin Khan

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 (e-mail address removed)
or
(e-mail address removed)

Thanks,

Shahin Khan
 
enter the date in Cell (example A1)

Create this formula in (Example B1) =A1+182 (182 for 6 months or 91 for 3
months). This formula simply takes the date and adds a certain number of
days to it.

Make sure that both cells are formatted to Date format
 
Hi,

Another way

=DATE(YEAR(A1),MONTH(A1)+3,DAY(A1))
and obviously +6 for 6 months

Mike
 
On Thu, 8 May 2008 08:44:02 -0700, Shahin Khan <Shahin
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 (e-mail address removed)
or
(e-mail address removed)

Thanks,

Shahin Khan
Click to expand...

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
 
In Excel 2007 or 03 with Analysis Toolpak Addin:
=EDATE(A2,3)
=EDATE(A2,6)
where A2 contains the original date...
 
Back
Top