Determine the date of the last Sunday in a month

Good morning all, I hope your XMAS and New Years

I am seeking a formula that will deliver me the date of specific days in the previous month and the following month, given a specific month as input data.

eg If I provide March 2011 as my input data, I need to get the dates of:
- the last Sunday in February 2011
- the first Saturday in April 2011
- the second saturday in April 2011

This will be an ongoing resource, which I will then be copying down indefinitely.
I know I could go through manually and input dates, but where is the fun in that?

In the attached example .. .cells B6 to E6 are what I am looking to auto-populate, given cell A6. and then copy down.

thanks in advance
Darren

Hello Darren, assuming A6 will be the 1st of the month you can get the last Sunday of the previous month with this formula in B6

=A6-WEEKDAY(A6-1)

Now for E6 use this formula for the first Saturday in the following month

=A6+39-DAY(A6+31)-WEEKDAY(A6+4-DAY(A6+31))

and clearly the second Saturday is 7 days after that so C6 can be just

=E6+7

all date cells should be formatted with the required format e.g. dd/mm/yyyy and formulas can be copied down the columns