Prev: Closing workbooks w/o closing Excel
Next: Excel 2003 help doesn't work. I got both Excel 2003 and 2007 insta
From: User on 16 Feb 2010 04:55
kindly advise a formula as per the below:

eg:- ISSUE DT EXPIRY DATE
30/12/2009 12/10/2010

I WANT TO EXTEND THE ABOVE DATE I.E., BY SAY 3 MONTHS SO THAT THE NEW DATE
BECOMES AS 12/01/2011.
From: Pete_UK on 16 Feb 2010 05:08
If your expiry date is in B2, then try this:

=DATE(YEAR(B2),MONTH(B2)+3,DAY(B2))

You should be aware of some consequences of just adding 3 months to a
date. If you have 30th Nov and add 3 months to it, then 30th Feb does
not exist, so the result will show as 2nd March.

Hope this helps.

Pete

On Feb 16, 9:55 am, User <U...(a)discussions.microsoft.com> wrote:
> kindly advise a formula as per the below:
>
> eg:-  ISSUE DT         EXPIRY DATE
>         30/12/2009       12/10/2010
>
> I WANT TO EXTEND THE ABOVE DATE I.E., BY SAY 3 MONTHS SO THAT THE NEW DATE
> BECOMES AS 12/01/2011.

From: Gary''s Student on 16 Feb 2010 05:28
With your data in A1 & B1, in C11 enter:
=DATE(YEAR(B1),MONTH(B1)+3,DAY(B1))

--
Gary''s Student - gsnu201001


"User" wrote:

> kindly advise a formula as per the below:
>
> eg:- ISSUE DT EXPIRY DATE
> 30/12/2009 12/10/2010
>
> I WANT TO EXTEND THE ABOVE DATE I.E., BY SAY 3 MONTHS SO THAT THE NEW DATE
> BECOMES AS 12/01/2011.
 | 
Pages: 1
Prev: Closing workbooks w/o closing Excel
Next: Excel 2003 help doesn't work. I got both Excel 2003 and 2007 insta