Count Number Of Days Except Sunday

[mgirvin]

Dear Smartest Excel People In The World,

In B13 I have the start date: 12/1/2008
In C13 I have the end date: 1/5/2009
In cell D13 I want a formula that counts the number of days between the two dates that are not Sunday. The start and end dates are included in the count.

I have created this formula using Ctrl + Shift + Enter:

{=SUM(IF(WEEKDAY(ROW(INDIRECT(B13&":"&C13)),2)<>7,1,0))}

I have also created this formula using Ctrl + Shift + Enter:

{=SUM(IF(TEXT(ROW(INDIRECT(B13&":"&C13)),"ddd")<>"Sun",1,0))}

They both seem to work. I get a result of 31.

Is there a formula that is better than this, more efficient than this, or "less expensive"?

 

[Ditzu77]

How about this way???
=C13-(WORKDAY.INTL(B13,35,11)-C13)-B13

 

[taurean]

Hi Ditzu77,

Welcome To MrExcel.

The function you've used was introduced in Excel 2010 and I think this discussion has taken place before that. You can take a look at similar discussions like this:
http://www.mrexcel.com/forum/showth...function-How-to-include-Saturdays-as-workdays

 

[barry houdini]

How about this way???
=C13-(WORKDAY.INTL(B13,35,11)-C13)-B13

Why 35, I'm not sure if that counts the Sundays between B13 and C13, is that the idea? In Excel 2010 the easiest way would be to use NETWORKDAYS.INTL, i.e.

=NETWORKDAYS.INTL(B13,C13,11)

 

[Ditzu77]

Good one Houdini! I've just joined today, but I already like this forum. Lots of help and good ideas.

The idea with my formula was that if u calculate the workdays without sundays, then the difference between the end date and the original end date would be the number of sundays between that period. Do I make any sense?)))