Go to Tools-Add-ins and make sure you have Analysis Toolpak checked, so that
you have access to

=EOMONTH()

"Grd" wrote:

Hi,

I need to get the last day of a month i.e 30/nov/05 out of todays date.
How do I go about this? Its driving me crazy.

Any help appreciated

Gordon