| Home |
| Search |
| Today's Posts |
|
#4
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
CALCULATE BETWEEN TWO DATES EXCLUDING WEEKENDS
On Thu, 3 Dec 2009 14:51:01 -0800, CYNTHIA wrote:
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 The "logic" of the NETWORKDAYS function is to include both the starting and ending days. After all, if you were a worker, and your first day of work was 11/2/09 and your last day of work was 11/5/09, you would want to be paid for four days and not three. If you want to do simple subtraction, then merely subtract 1 from the networkdays answer. --ron |
| 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
