ExcelBanter - enter month end date

ExcelBanter (https://www.excelbanter.com/)

- Excel Worksheet Functions (https://www.excelbanter.com/excel-worksheet-functions/)

- - enter month end date (https://www.excelbanter.com/excel-worksheet-functions/47318-enter-month-end-date.html)

tjb

enter month end date

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!

"tjb" wrote:

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

Sandy Mann

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?

Ron de Bruin

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?

All times are GMT +1. The time now is 02:51 AM.