formula to calculate month-month
 

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.

formula to calculate month-month
 

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 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.

formula to calculate month-month
 

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.