| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Count days without weekends
Hello is there any day that I can count days between two dates without
including weekends? Please see below an example: Date1 Date2 # of business days 3/19/08 3/24/08 3 3/20/08 3/24/08 2 3/21/08 3/24/08 1 3/24/08 3/24/08 0 3/24/08 3/25/08 1 |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Count days without weekends
See NETWORKDAYS in Help.
Compare Values wrote: Hello is there any day that I can count days between two dates without including weekends? Please see below an example: Date1 Date2 # of business days 3/19/08 3/24/08 3 3/20/08 3/24/08 2 3/21/08 3/24/08 1 3/24/08 3/24/08 0 3/24/08 3/25/08 1 |
|
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Count days without weekends
See NETWORKDAYS function in Help.
Enter =NETWORKDAYS(A1,B1) in C1 and copy down. Note: the function counts both start and end date so your 3 will be 4 etc. Note: the ATP must be loaded. Gord Dibben MS Excel MVP On Mon, 7 Apr 2008 13:02:01 -0700, Compare Values wrote: Hello is there any day that I can count days between two dates without including weekends? Please see below an example: Date1 Date2 # of business days 3/19/08 3/24/08 3 3/20/08 3/24/08 2 3/21/08 3/24/08 1 3/24/08 3/24/08 0 3/24/08 3/25/08 1 |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Exclude weekends when counting days only on day 29 or 30 | Excel Worksheet Functions | |||
| How do I add business days to a date field, no weekends? | Excel Worksheet Functions | |||
| How do I set up a clumn of days, skipping weekends? | Excel Worksheet Functions | |||
| How do you count work days excluding weekends and holidays? | Excel Discussion (Misc queries) | |||
| Formula to make Excel count business days/skip weekends? | Excel Worksheet Functions | |||
Hybrid Mode
