Forum Discussion
Help me skip sundays for a work week!
This is the formula that came with the template. I need to my days to skip sundays when I enter "no. of days". I need this for a construction timeline but we are not working sundays. What can I put in the formula to exclude those days? Thank you!!
=IF(AND($C9="Goal",N$5>=$F9,N$5<=$F9+$G9-1),2,IF(AND($C9="Milestone",N$5>=$F9,N$5<=$F9+$G9-1),1,""))
14 Replies
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.
