Counting between 2 dates not including wkends
Closed
HannahBanana
-
Aug 1, 2010 at 08:08 AM
Game Start Now
Game Start Now
- Posts
- 138
- Registration date
- Thursday January 21, 2010
- Status
- Member
- Last seen
- May 8, 2019
Related:
- Counting between 2 dates not including wkends
- Calculate Time Between 2 Dates in Excel - How-To - Excel
- Greater than/Less than between 2 Dates ✓ - Forum - Excel
- Sumif formula to sum between 2 dates...help ✓ - Forum - Office Software
- Excel - Count 2 values in one column and 1 value in other - How-To - Excel
- How to count number of cells dated this week? or next week? ✓ - Forum - Excel
3 replies
Game Start Now
Aug 1, 2010 at 01:36 PM
- Posts
- 138
- Registration date
- Thursday January 21, 2010
- Status
- Member
- Last seen
- May 8, 2019
Aug 1, 2010 at 01:36 PM
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 ?
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 ?
Game Start Now
Aug 2, 2010 at 12:37 AM
- Posts
- 138
- Registration date
- Thursday January 21, 2010
- Status
- Member
- Last seen
- May 8, 2019
Aug 2, 2010 at 12:37 AM
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..........
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..........