Re: How can I find out what date going to be 3 month from today in ex by Ron
Ron
Thu May 08 11:28:32 CDT 2008
On Thu, 8 May 2008 08:44:02 -0700, Shahin Khan <Shahin
Khan@discussions.microsoft.com> 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 shahin512@hotmail.com
> or
> shahin512@gmail.com
>
>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