Scheduler formulas not quite right.

[marz73]

Good day everyone! I’m trying to create a list of dates that will automatically update when the value of cell C4 is changed. Cells C7 through C14 work as I needed them. The first issue I’m having starts with Cell C16. Cell C16 needs to be the following Monday from C14, no matter what date is returned in cell C14 when Cell C4 is changed, C16 needs to be the Monday that follows C14, unless it’s a holiday then Tuesday. Then Cells C17 to C34 need to display the First workday of that week omitting Monday Holidays (listed in G8-G12). I have uploaded my attempt. I genuinely appreciate all help and any input!

 

[Legacy 143009]

Try in C16:

=IF(COUTNIF($G$8:$G$12,C14+(7-WEEKDAY(C14,2)+1))=0,C14+(7-WEEKDAY(C14,2)+1),"")

 

[marz73]

Try in C16:

=IF(COUTNIF($G$8:$G$12,C14+(7-WEEKDAY(C14,2)+1))=0,C14+(7-WEEKDAY(C14,2)+1),"")

I got a return of #NAME? when I put =IF(COUTNIF($G$8:$G$12,C14+(7-WEEKDAY(C14,2)+1))=0,C14+(7-WEEKDAY(C14,2)+1),"") in cell C16

 

[Legacy 143009]

Countif has a typo, sorry. Also you may sum with row number in order to get following values:

=IF(COUNTIF($G$8:$G$12,C14+(7-WEEKDAY(C14,2)+1))=0,(C14+(7-WEEKDAY(C14,2)+1))+(ROW()-16),"")

 

[marz73]

awesome! Cell C16 works!!! Thanks a ton!!!!!! I dragged it down to cell C34 and once the holiday 5/29/2023 comes up I get a blank cell in C30?

 

[Legacy 143009]

Do you want to display holiday?