• 463K Members
• 6,912 Online
• 560K Conversations

New Contributor

# 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,""))

5 Replies

# Re: 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,"")))`

# Re: Help me skip sundays for a work week!

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

@Sergei Baklan 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,"")))`

# Re: Help me skip sundays for a work week!

Did you check the file I applied to my previous post? Updated formula is applied to couple of first rows.

# Re: Help me skip sundays for a work week!

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)??

@Sergei Baklan wrote:

Did you check the file I applied to my previous post? Updated formula is applied to couple of first rows.

# Re: Help me skip sundays for a work week!

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.

Related Conversations
Tabs and Dark Mode
cjc2112 in Discussions on
46 Replies
Extentions Synchronization
Deleted in Discussions on
3 Replies
Stable version of Edge insider browser
HotCakeX in Discussions on
35 Replies
flashing a white screen while open new tab
Deleted in Discussions on
14 Replies
How to Prevent Teams from Auto-Launch
chenrylee in Microsoft Teams on
29 Replies
Security Community Webinars
Valon_Kolica in Security, Privacy & Compliance on
13 Replies