Validating WEEKNUM odd/even to set up schedule

[cparks]

Real quick.

I'm setting up a work schedule that keeps the same days every other week. I'm trying to figure out a better way to extract dates given 2 criteria:

1. If the WEEKNUM is odd/even
2. If odd, extract Sun, Mon, Tues; If even, extract Mon, Tues, Wed, Sat.

I have uploaded an example of what my data looks like.

I already have an array formula to extract the dates and place them in my calendar. I just need a formula to only show dates from the 2 criteria.

Thanks to anyone for any help.

CP

 

[John Jairo V]

Hi!

You can use this formulae (D2 and drag it down):

=IF(OR(WEEKDAY(A2)={2;3},(1-C2)*(WEEKDAY(A2)={4;7}),C2*(WEEKDAY(A2)=1)),A2,"")

Blessings!

 

[cparks]

WOW. Yeh, when there's multiplication with other formulas, it just blows my mind.

I would have never figured that one out they way you have it. Awesome! Many thanks!!!