| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Networkdays function doesn't find true difference between two dat
I am trying to use networkdays function. Please note your help on this topic
- I have pasted the e.g. in question below: a2 = 6/8/2007 a3 = 6/20/2007 Formula Description 1. =A3-A2 Days between the two dates (12) 2. =NETWORKDAYS(A2,A3) Weekdays between the two dates (9) The difference in 1 is correct - there is 12 days between - i am trying to find a duration period here. The difference in 2 is incorrect - 12 days - 4 weekend days - should be 8 It seems to be including the start date which is what happens when I uses this function in my spreadsheet. It is calcuating 1 extra day. Please tell me how this function can work correctly. I cant just take 1 day off as it might not always span a weekend. |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Lookup Data in two seperate Spreadsheets | Excel Worksheet Functions | |||
| Can't use Find function in formula | Excel Discussion (Misc queries) | |||
| how to find time difference between timestamps to a millisecond? | New Users to Excel | |||
| What function would let me find Batting Averages? | Excel Worksheet Functions | |||
| What function would let me find Batting Averages? | Excel Worksheet Functions | |||
Threaded Mode
