Excel 2003 - VBA - Working with Dates

[Craig Brandt]

Does anyone have and idea how to create the date of the last day of the
previous month?

Craig

 

[Harald Staff]

Hi Craig

=Dateserial(year(date), month(date), 0)

HTH. Best wishes Harald

 

[Bob Phillips]

=TODAY()-DAY(TODAY())

 

[Rick Rothstein]

Assuming the OP actually needs this in VBA (as his Subject seems to
indicate), the VB equivalent of your worksheet formula is this...

LastDayOfPreviousMonth = Date - Day(Date)

 

[Craig Brandt]

Thanks for all your help. The entry showing the code for VBA nailed it.

Craig