I apologize file not attached to first post

here is the same question with the sheet attached - again sorry for the miscue

First off let me thank you in advance if you can help me

I have tried to be as detailed as possible - I am fairly new to using formulas

my objective is to display (daily completion goal) in each cell in "column c" for actual days worked
c35 - d35 / c2
monthly audits to complete 177(c35)
total completed to date 0(d35)
total work days is 19 (c2)

holiday and days off JAN 1,2,3,13 (cells m2-s2) and weekend days

conditional formatting is applied to "=$A$4:$S$34" using formula "=WEEKDAY($A4,2)>5" which fills sat/sun rows in red

I would like to find the average, and have that entered in cells showing "goal"

the average will change daily based on what is entered in d9,d10,d11 etc...

below request is not vital however it would be a bonus if it can be done

is it possible to lock the original (goal) in c9... after data(#completed) is entered in d9 , recalculate the (goal) for the remaining workdays, re-populate c10 - c33 with the new goal, and recalculate again after each day's "Audits completed" total is entered

Attached Files

Book2 test.xlsx (17.1 KB, 11 views)