# Count Days EXCLUDING ONLY Sundays and a named range for Holidays

1. ## Count Days EXCLUDING ONLY Sundays and a named range for Holidays

Hello!

I'm struggling to find a way to count the number of days between 2 dates excluding only Sundays and a named range for Holidays.

=Networkdays(B2,A2,Holidays) does not work (as shown) as it also excludes Saturdays. Essentially, this program is to count delivery days for U.S. mail.

An example spreadsheet is attached which provides a bit more clarity as to what I'm trying to accomplish.ExcelForum - Count_Days.xlsx

Using Excel 2010.

Any assistance would be greatly appreciated!

Thanks so much!!!

Seaplane Jack

2. ## Re: Count Days EXCLUDING ONLY Sundays and a named range for Holidays

``Please Login or Register  to view this content.``

3. ## Re: Count Days EXCLUDING ONLY Sundays and a named range for Holidays

Or try:
=NETWORKDAYS(A2,B2,Holidays)+INT((B2-A2-WEEKDAY(B2-6)+8)/7)

4. ## Re: Count Days EXCLUDING ONLY Sundays and a named range for Holidays

ExcelForum - Count_Days - Rev1.xlsxI've been playing with both suggestions above and can't get either to work for excluding Sundays. They both work when a holiday is involved, but no matter what I do I can't get them to "account for" Sundays.

See the revised spreadsheet example attached. Whether using a simple formula (=B2-A2) or one of the suggestions above, both show 3 days when the actual result should be 2 since Jan 05 is a Sunday.

Am I doing something wrong (wouldn't be the first time)???

Thanks, again!!!

Seaplane Jack

5. ## Re: Count Days EXCLUDING ONLY Sundays and a named range for Holidays

Netowrkdays is INCLUSIVE, meaning it counts BOTH the start date AND the end date.
So your dates in A2 and B2 are from Friday to Monday
Excluding only Sunday, then it counts Friday Saturday and Monday = 3

To correct for this, either add 1 to the start date, or subract 1 from the end date
Depending on if you want to exclude the Start or End date..

Exclude Start Date from the count
=NETWORKDAYS.INTL(A2+1,B2,11,Holidays)

Exclude End Date from the count
=NETWORKDAYS.INTL(A2,B2-1,11,Holidays)

Hope that helps.

6. ## Re: Count Days EXCLUDING ONLY Sundays and a named range for Holidays

Ok...that makes perfect sense and now works perfectly!

Thank you so very, very much!!!

Best Regards,

Seaplane Jack

7. ## Re: Count Days EXCLUDING ONLY Sundays and a named range for Holidays

Ok...that makes perfect sense and now works perfectly!

Thank you so very, very much!!!

Best Regards,

Seaplane Jack

8. ## Re: Count Days EXCLUDING ONLY Sundays and a named range for Holidays

You're welcome..

FYI,

DON'T do it this way
=NETWORKDAYS.INTL(A2,B2,11,Holidays)-1
That could have inaccurate results..

Always Add to the start date or Subtract from the End date.

##### Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

#### Posting Permissions

• You may not post new threads
• You may not post replies
• You may not post attachments
• You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1