| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
CALCULATE BETWEEN TWO DATES EXCLUDING WEEKENDS
A) B)
11/20/09 11/23/09 11/2/09 11/5/09 When I use the Network formula it says 4 days which is incorrect for the 11.20.09 date. I use the formula NETWORKDAYS(A1,B1) also when i use to calculate 11/2/09 and 11/5/09 which i know are not weekend dates but regular business dates it says 4 days which is wrong its 3 days I use the formula NETWORKDAYS(A1,B1) Please help me |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Calculate A Date Excluding Weekends And Holidays | New Users to Excel | |||
| Calculate End Date (excluding weekends and holidays) | Excel Worksheet Functions | |||
| Calculate the time difference excluding weekends and out of businesshours ( i.e. 8AM - 5 PM) | Excel Worksheet Functions | |||
| Calculate number of hours between dates and times excluding Weekends | Excel Discussion (Misc queries) | |||
| Calculate A Date Excluding Weekends And Holidays | New Users to Excel | |||
Threaded Mode
