Another way...

This requires the Analysis ToolPak add-in be installed for Excel versions
prior to Excel 2007.

A1 = some date

=EOMONTH(A1,0)

Format as Date

--
Biff
Microsoft Excel MVP


"Siralec" wrote in message
...
User enters a specific date, I'd like to round that entry to the end of
the
month