Formula for Showing he DATE on every Friday Excluding Holidays

[matthewlouis]

Looking for a formula that shows every Friday date that is NOT a holiday.

I have a list of holidays I can put in the formula.

Thanks in advance!

 

[Fluff]

Is that every Friday for the year, the month or something else?

 

[matthewlouis]

Every Friday for the year since 1970 to copy and paste down with most current at top

 

[Fluff]

Ok, how about

Fluff.xlsm
	A	B	C	D	E	F	G
1	Fridays
2	18/11/2022						11/11/2022
3	04/11/2022						14/10/2022
4	28/10/2022						26/08/2022
5	21/10/2022						15/07/2022
6	07/10/2022
7	30/09/2022
8	23/09/2022
9	16/09/2022
10	09/09/2022
11	02/09/2022
12	19/08/2022
13	12/08/2022
14	05/08/2022
15	29/07/2022
16	22/07/2022
17	08/07/2022
18	01/07/2022
19	24/06/2022
20	17/06/2022
21	10/06/2022
22	03/06/2022
23	27/05/2022
24	20/05/2022
25	13/05/2022
26	06/05/2022
27	29/04/2022
28	22/04/2022
29	15/04/2022
30	08/04/2022
Main

Cell Formulas
Range	Formula
A2:A2757	A2	=LET(d,DATE(1970,1,1),SORT(WORKDAY.INTL(d,SEQUENCE(NETWORKDAYS.INTL(d,TODAY(),"1111011",G2:G20)),"1111011",G2:G20),,-1))
Dynamic array formulas.

 

[matthewlouis]

OK, let me try that, thanks!!

 

[matthewlouis]

What is Column G? How did you get that?

 

[Fluff]

That's just a list of holiday dates.

 

[matthewlouis]

Ah, OK, let me try that

 

[matthewlouis]

Great! Works. QUESTION: How do I make it every Monday that skips Monday holidays?

 

[Fluff]

Just change both sets of "1111011" to "0111111"