# date function which did not include sunday

1. ## date function which did not include sunday

Hi,

I am required to calculate the number of days between two dates exclude sunday. Can someone please provide me such formulae?

Thanks

2. ## Re: date function which did not include sunday

try this forumla

3. ## Re: date function which did not include sunday

It looks complicated. Is there a simplier solution?

Thanks

4. ## Re: date function which did not include sunday

Is there a simplier solution?

5. ## Re: date function which did not include sunday

Hello Harold

try this formula.
excel 2007, 2010

``Please Login or Register  to view this content.``
note:
B1 - start date
B2 - End Date
11 - Sunday only(you can choose )
F2 - cell containing a special holiday that you want to Exclude
Hole That Helps

Similar with NETWORKDAYS Function in excel 2003

6. ## Re: date function which did not include sunday

If the end date is empty, how can i have the result display as N/A?

Thanks again

7. ## Re: date function which did not include sunday

can someone please look into it?

Thanks

8. ## Re: date function which did not include sunday

Please allow 24 hrs before bumping, you are not the only one waiting for help

If it is urgent you can always try commercial help.

9. ## Re: date function which did not include sunday

thank you very much indeed

10. ## Re: date function which did not include sunday

Here you go:
=NETWORKDAYS.INTL(B1,B2,11)

Jeremy

Jeremy

12. ## Re: date function which did not include sunday

How come sunday is treated as 11?

13. ## Re: date function which did not include sunday

Originally Posted by Harrold
How come sunday is treated as 11?
Different types of weekends have different codes, for example 1 is the standard Saturday/Sunday weekend, 11 is Sundays only - see help files for more

Originally Posted by Harrold
If the end date is empty, how can i have the result display as N/A?
Try this version

=IF(B2="","N/A",NETWORKDAYS.INTL(B1,B2,11))

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