use:

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

- Mangesh



"Matt D Francis" wrote in message
...
Hi,

I need to be able to enter a date in a cell and have the cell next to it
return the corresponding month-end date. I'm sure it's simple but I
couldn't
find a dedicated function.

e.g

A1 = 03/01/2005
A2 = 31/03/2005 (calculated)

or

A1 = 17/021/2005
A2 = 28/02/2005 (calculated)

etc