I modified your's ... does this make sence..seem's to work
=DATE(YEAR(B2)+2,MONTH(B2)+1,DAY(B2)-DAY(B2)+1)
"Frank Kabel" wrote:
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?
|