Monthly task schedule that repeats dates on Weekends and Holidays

Hi All

I'm new to the forum - and am grateful for the tips I've learned so far.

I have a problem where in my monthly list, I need to schedule several tasks on a given day (usually weekends), so need to repeat the date X times (e.g. repeat Saturdays date 4x and Sundays 3x for the month), with other dates just appearing once. I thought I found a solution on here, but can't locate it.

The top/ first cell (green) B2 is always the first of the month, and by inserting a number against the day of the week (column F), I can repeat that day of the week in the schedule. Perfect! However, I also need to reference holiday dates, so on these special days the date is repeated twice and I'm stuck because I don't know how to reference holiday dates (column I) in the formula that I have (B3 onwards). I've stumbled and played around with the formula, but get consistent errors - my brain is fried!!! I think I need a VLookup or something - but I have no experience of this. Any help welcome.

Days in column E typed as texts, formula in J2=TEXT(K2,"ddd"), helper column G2=COUNTIF($J$2:$J$10,E2), helper column H2=SUM(F2:G2), and formulas in column B referencing to column H.

Your formula means that the list of days are multiplied by the helper column (Column H) even if the holiday date is not included in the current month/ period. Thanks for trying.

Originally Posted by kvsrinivasamurthy

In C3 then copy down.

Please Login or Register  to view this content.

Note change in E2:E8
Values in F2 :F8 can be changed.
No helper columns.

Thanks for this. I extended Column B to end of month, but holiday dates 15/04/22 and 18/04/22 were not repeated. In Column B these dates were missing. Still unsure how to calculate by thanks for trying.

Originally Posted by Laverne Anderson

Thanks for this. I extended Column B to end of month, but holiday dates 15/04/22 and 18/04/22 were not repeated. In Column B these dates were missing. Still unsure how to calculate by thanks for trying.

What if a holiday date is sunday or saturday ?