You're welcome. Thanks for the feedback!

--
Biff
Microsoft Excel MVP


"Steve" wrote in message
...
Works fine. Thanks guys
Steve

"T. Valko" wrote:

If you have the Analysis ToolPak add-in installed (Excel versions prior
to
Excel 2007):

A1 = some date

=EOMONTH(A1,0)

--
Biff
Microsoft Excel MVP


"Steve" wrote in message
...
Is there a way, using a macro to calculate the last date for a month
when
the
fist day of the month is input?
examples:
Input 10/1/2008
Result 10/31/2008

Input 8/1/2008
Result 8/31/2008

Thanks
Steve