calculate last monday of the month

A

Allen Browne

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.
 
S

steve

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
 
Top