Previous Topic Next Topic

Counting between 2 dates not including wkends

Closed
HannahBanana - 1 Aug 2010 à 08:08
Game Start Now Posts 138 Registration date Thursday 21 January 2010 Status Member Last seen 8 May 2019 - 2 Aug 2010 à 00:37
Hello,

I ma trying to count between 2 dates not including weekends i am trying to use =IF(OR(C17="",D17=""),"",NETWORKDAYS(C17,D17)-1)
C17 and D17 being the two dates
but it is not working the answer is wrong. Example of this

C17 is 19/07/10 and D17 is 23/07/10 the asnwer is coming up with 4 but the answer I want is 2 because it has 2 working days

can you help??
Related:

3 responses

Réponse 1 / 3
Game Start Now Posts 138 Registration date Thursday 21 January 2010 Status Member Last seen 8 May 2019 7
1 Aug 2010 à 13:36
I Think From 19-07-2010 to 23-07-2010 the working days are 5.

because holidays are saturday & sunday.

19-07-2010 is on Monday
20-07-2010 is on Tuesday
21-07-2010 is on Wednesday
22-07-2010 is on Thursday
23-07-2010 is on Friday
Means All Are Working Day

You Should Get The Answer Of 5
why you want the answer 2 ?
Réponse 2 / 3
Hannah Banana
1 Aug 2010 à 14:04
Sorry I meant August 19/08/10 not july!? this is giving me a headache!?
Réponse 3 / 3
Game Start Now Posts 138 Registration date Thursday 21 January 2010 Status Member Last seen 8 May 2019 7
2 Aug 2010 à 00:37
Means From 19-08-2010 to 23-08-2010.

Your Answer Should Be 3

19-08-2010 is on Thursday (Means Working Day)
20-08-2010 is on Friday (Means Working Day)
21-08-2010 is on Saturday (Means Holiday)
22-08-2010 Is on Sunday (Means Holiday)
23-08-2010 Is on Monday (Means Working Day)

Means Your Answer Should Be 3 Right.........

If Yes Than Tell Me...

I Will Tell You Your Formula..........

Similar discussions

Sims 2!! Custom content pleasee helpp me!! :(
smiley cupcakee xx :] -
Levy -

25 responses