Try:

=DATE(YEAR(A1),MONTH(A1)+1,1)-1

--
HTH

Sandy

Replace@mailinator with @tiscali.co.uk


"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?