G Guest Mar 13, 2005 #1 Question.. a document expires in the end of month, 5 years ahead. How do I get this result from the start date?
Question.. a document expires in the end of month, 5 years ahead. How do I get this result from the start date?
N Niek Otten Mar 13, 2005 #2 =DATE(YEAR(A1)+5,MONTH(A1)+1,0) -- Kind Regards, Niek Otten Microsoft MVP - Excel
