I've used the following formula to get the nth xday of the month:
where year is in B2 and month (as a number from 1 to 12) is in A2, and where
xday is a number representing the day of the week (1 = Sun through to 7 = Sat), so for 1st Saturday that becomes:
Now, this works for months with 4 weeks. How can I modify this formula to calculate when a month has 5 weeks?