Thread: Calculate due date 1 or 2 years ahead to the first of the followi.
View Single Post
  #2   Report Post  
Frank Kabel
 
Posts: n/a
Default
Hi
=DATE(YEAR(A1)+2,MONTH(A1),DAY(A1))

--
Regards
Frank Kabel
Frankfurt, Germany

Wayne wrote:
Issue date is June 12,2004. Certificate is valid ( 24 months ) to
July 01, 2006. How do I create this is XL?


Reply With QuoteReply With Quote