Forum Discussion
Help me skip sundays for a work week!
I adjusted first part of the formula for Goal. For Milestone it shall be similar, but better to have some data to test.
=IF(WEEKDAY(I$5,2)=7,"",IF(AND($C9="Goal",I$5>=$F9,NETWORKDAYS.INTL($F9,I$5,11)<=$G9),2,IF(AND($C9="Milestone",I$5>=$F9,I$5<=$F9+$G9-1),1,"")))
I attached the file to the post. I tried pasting what you provided in the box and it did not fix my issue. It's still counting sunday. Thank you though
SergeiBaklan wrote:I adjusted first part of the formula for Goal. For Milestone it shall be similar, but better to have some data to test.
=IF(WEEKDAY(I$5,2)=7,"",IF(AND($C9="Goal",I$5>=$F9,NETWORKDAYS.INTL($F9,I$5,11)<=$G9),2,IF(AND($C9="Milestone",I$5>=$F9,I$5<=$F9+$G9-1),1,"")))
Did you check the file I applied to my previous post? Updated formula is applied to couple of first rows.
Wow! Thank you! That's exactly what I need it to do. Now how can I apply the same formula to the remaining sundays (columns)??
SergeiBaklan wrote:Did you check the file I applied to my previous post? Updated formula is applied to couple of first rows.
Stay on the top left cell (I9) and drag it to the right till end of the time scale
Next drag entire this row down till end of your range.