enter month end date

[tjb]

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

 

[tjb]

I figured it out. thanks to anyone who's already replied!

 

[Sandy Mann]

Try:

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

--
HTH

Sandy
[email protected]
Replace@mailinator with @tiscali.co.uk

 

[Ron de Bruin]

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