| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
need help with networkdays formula
want to setup formula using networkdays through which end date which is 30
workingdays from start date can be calculated. |
|
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
need help with networkdays formula
With a start date in A1 try this:-
=WORKDAY(A1,30,C1:C8) C1 - C8 are a list of public holidays. This argument is optional soo you could use. =WORKDAY(A1,30) Mike "aashishtaneja" wrote: want to setup formula using networkdays through which end date which is 30 workingdays from start date can be calculated. |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| how to include saturdays in networkdays formula | Excel Discussion (Misc queries) | |||
| Array Formula - NetworkDays | Excel Discussion (Misc queries) | |||
| Networkdays formula | Excel Worksheet Functions | |||
| NETWORKDAYS FORMULA | Excel Worksheet Functions | |||
| NETWORKDAYS help with the formula | Excel Discussion (Misc queries) | |||
Linear Mode
