calculate last monday of the month

  • Thread starter Thread starter steve
  • Start date Start date
Try:

DateSerial(Year(Date), Month(Date) + 1, 1) - Weekday(DateSerial(Year(Date),
Month(Date) + 1, 1), 3)

That expression calculates the first of next month, and then takes off the
day of the week, assuming Tuesday to be the first day of the week.
 
After playing with it a bit I found that
=DateSerial(Year([Date]),Month([Date])+0,1)-Weekday(DateSerial(Year([Date]),
Month([Date])+1,1),6) works. Wish I understood why? :)

Thanks
 
Back
Top