• Hi All

    Please note that at the Chandoo.org Forums there is Zero Tolerance to Spam

    Post Spam and you Will Be Deleted as a User

    Hui...

  • When starting a new post, to receive a quicker and more targeted answer, Please include a sample file in the initial post.

hello excel ninjas

Y

ysahme

New Member
Date Started Date End Days pass

1/2/13 1/12/13 10

1/8/13 1/12/13 4


i want to count the days pass except Sunday.

do you have a formula that less the count of Sunday..

Thanks in Advance...
 
Hi ,


You can take the difference between the two dates , and subtract the number of Sundays from this :


=(End_date - Start_date) - SUM(IF(WEEKDAY(ROW(INDIRECT(Start_date&":"&End_date)))=1,1,0))


entered as an array formula , using CTRL SHIFT ENTER.


Narayan
 
Ysahme


Assuming your dates are mm/dd/yy above

1/2/13 to 1/12/13 is 11 days of which there is 1 Sundays

So I get 11 not 10 as you posted

I would use: =NETWORKDAYS.INTL(A2,B2,11)


1/8/13 to 1/12/13 is 5 days of which there are no Sundays

So I get 5 not 4 as you posted

I would use: =NETWORKDAYS.INTL(A3,B3,11)


My counts above include both the Start and End dates so you can take off another 1 or 2 if they aren't included


So the formula could be:

=NETWORKDAYS.INTL(A2,B2,11)-1

to match your answers
 
You must log in or register to reply here.
Back
Top