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

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

Shahin Khan - 08 May 2008 16:44 GMT

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 shahin512@hotmail.com
or
shahin512@gmail.com

Thanks,

Shahin Khan

Reply to this Message

Susan - 08 May 2008 16:56 GMT

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

Signature

Thanks!
Susan

> 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.
[quoted text clipped - 6 lines]
>
> Shahin Khan

Reply to this Message

Mike H - 08 May 2008 17:09 GMT

Hi,

Another way

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

Mike

> 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.
[quoted text clipped - 6 lines]
>
> Shahin Khan

Reply to this Message

David Biddulph - 08 May 2008 17:14 GMT

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

> 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.
[quoted text clipped - 6 lines]
>
> Shahin Khan

Reply to this Message

Ron Rosenfeld - 08 May 2008 17:28 GMT

>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.
[quoted text clipped - 6 lines]
>
>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

Reply to this Message

BoniM - 08 May 2008 17:36 GMT

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

> 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.
[quoted text clipped - 6 lines]
>
> Shahin Khan

Reply to this Message