you can do this
=DATE(YEAR(A1),MONTH(A1)+1,0)

--
Regards Ron de Bruin
http://www.rondebruin.nl


"tjb" wrote in message ...
When a user enters a date in A1, I want A2 to give me the last day of the
month from A1. Any ideas?