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

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
--
Thanks!
Susan


"Shahin Khan" 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

Hi,

Another way

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

Mike

"Shahin Khan" 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

=DATE(YEAR(A1),MONTH(A1)+3,DAY(A1))
=DATE(YEAR(A1),MONTH(A1)+6,DAY(A1))
--
David Biddulph

"Shahin Khan" <Shahin wrote in message
...
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

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

In Excel 2007 or 03 with Analysis Toolpak Addin:
=EDATE(A2,3)
=EDATE(A2,6)
where A2 contains the original date...

"Shahin Khan" 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