End of month in the future..

Kane · Mar 13, 2005

Question.. a document expires in the end of month, 5 years ahead. How do I
get this result from the start date?

Niek Otten · Mar 13, 2005

=DATE(YEAR(A1)+5,MONTH(A1)+1,0)

--

Kind Regards,

Niek Otten

Microsoft MVP - Excel

Kane · Mar 13, 2005

Thanks Niek ... just what I needed! Have a nice day... Kane