Finding which specific day comes first in any given month.

[kirash4]

Hi All,

I need a column that lists all Tuesday, Wednesday, and Fridays in any given month, sorted by the date. For example, for January 2022, Tuesday 4th is the first day of those three, so the column would start with that date. But for April 2022, Friday 1st happens to be the first of the three days. And for June 2022, Wednesday 1st is the first of the three days. I suppose technically I only need the first three instances in each month, then build the remainder of the column by simply adding 7 days each time (till the end of the month.)

My question is whether there's a way to do this with formulas or do I have to resort to using VBA? I've attached a workbook that contains the result of what I'd like to end with.

I appreciate any guidance or pointers to possible solutions.

Thanks!

[alansidman]

See attached spreadsheet in which I created a lookup using a parameter query.

[CARACALLA]

A2=FILTER(TEXT(ROW(INDIRECT(A$1&":"&EOMONTH(A$1,0))),"DDD,MMMM DD,YYYY"),ISNUMBER(MATCH(TEXT(ROW(INDIRECT(A$1&":"&EOMONTH(A$1,0))),"DDD"),$E$2:$E$4,0)))


Copy across

[kirash4]

Ah, thank you both for your responses. I choose to go with CARACALLA's solution as that doesn't require a macro. I'm trying to avoid having to use VBA for this project. Thank you!