formula to calculate month-month

[User]

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.

 

[Pete_UK]

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

 

[Gary''s Student]

With your data in A1 & B1, in C11 enter:
=DATE(YEAR(B1),MONTH(B1)+3,DAY(B1))