View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
user user is offline
external usenet poster
 
Posts: 44
Default 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.