End of month in the future..
 

Question.. a document expires in the end of month, 5 years ahead. How do I
get this result from the start date?
A1 ... Start date mm/dd/yyyy
A2 ... (Due date) doc expires end of month, 5 yr from start

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

--

Kind Regards,

Niek Otten

Microsoft MVP - Excel

"Kane" wrote in message
...
Question.. a document expires in the end of month, 5 years ahead. How do I
get this result from the start date?
A1 ... Start date mm/dd/yyyy
A2 ... (Due date) doc expires end of month, 5 yr from start

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

"Kane" wrote:

Question.. a document expires in the end of month, 5 years ahead. How do I
get this result from the start date?
A1 ... Start date mm/dd/yyyy
A2 ... (Due date) doc expires end of month, 5 yr from start