C
Craig Brandt
Does anyone have and idea how to create the date of the last day of the
previous month?
Craig
previous month?
Craig
You are using an out of date browser. It may not display this or other websites correctly.
You should upgrade or use an alternative browser.
You should upgrade or use an alternative browser.
H
Harald Staff
Hi Craig
=Dateserial(year(date), month(date), 0)
HTH. Best wishes Harald
=Dateserial(year(date), month(date), 0)
HTH. Best wishes Harald
B
Bob Phillips
=TODAY()-DAY(TODAY())
R
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)
indicate), the VB equivalent of your worksheet formula is this...
LastDayOfPreviousMonth = Date - Day(Date)
C
Craig Brandt
Thanks for all your help. The entry showing the code for VBA nailed it.
Craig
Craig