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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Number of Mondays in month 3
Last Monday of the Month 3
generating dates on a report 4
Recurring events 1
Count Mondays worked in Month 2
Trying to calculate tutor hours when student classes overlap 8
Cell should calculate the date of monday 3
autorun print a report (on 1st monday of every month) 1

Back
Top