C Craig Brandt Sep 10, 2008 #1 Does anyone have and idea how to create the date of the last day of the previous month? Craig
H Harald Staff Sep 10, 2008 #2 Hi Craig =Dateserial(year(date), month(date), 0) HTH. Best wishes Harald
R Rick Rothstein Sep 11, 2008 #4 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)
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)
C Craig Brandt Sep 11, 2008 #5 Thanks for all your help. The entry showing the code for VBA nailed it. Craig
