formula to calculate month-month

  • Thread starter Thread starter User
  • Start date Start date
U

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