You probably somehow calculate end of week which is used in "net work days" row. Instead of using this date, use such formula
Formula:
MIN(the_date_of_end_of_week, EOMONTH(your_date_from_Week_Starting_row,0)
This deald with "5 instead of 3" problem
also you can calculate a difference of "old approach count" - "new approach count" for previous week and if its >0 (you can use function MAX(0,calculated difference) add it to current week count.
Anyway - with the attachment the help would be with "excact formulas", but may be you will be able to create them yourself with the above propositions.
Bookmarks