Populate future dates that fall on specific weekdays

[ollyhughes1982]

Hi,

Please could someone help with this query. I am looking to populate two of my worksheets.

In the ‘C Bingo Planner’ worksheet, I am looking to find a formula that populates the cells B3:AF368with either a 1 or a 2, according to the following criteria:

- First criteria: I want to populate cells B3:AF368 with a 1, but only where the the Day & Month combination either fall on a Saturday, Christmas Day or New Year's Day. - I have conditionally formatted these cells so they will turn blue.

- Second criteria: If the Day & Month combination HAS already been completed (check in 'All Completed Runs'!E3:E232') then put a 2. - I have conditionally formatted these cells so they will turn green.

In the ‘All Completed Runs - C Bingo’ worksheet, I want to populate the list with the first date and venue on which the Date & Month combination were completed.

I have manually populated the cells in this worksheet to show what I’m trying to achieve.

Thanks in advance!

Also posted on Mr. Excel forum: https://www.mrexcel.com/board/thread...kdays.1130189/

[harrisonland]

Try pasting this in B3:

Please Login or Register  to view this content.

and copying down and across.

See attached for a breakdown of the above.

HTH
Tim