| Home |
| Search |
| Today's Posts |
|
#7
Posted to microsoft.public.excel.programming
|
|||
|
|||
Week starts on Saturday - Working days
It should have been =NETWORKDAYS(C14+2,D14+2)
-- HTH Bob Phillips (remove xxx from email address if mailing direct) wrote in message oups.com... hello Tom, Thanks a lot. If I quote your formula I receive 3 working days but if I quote your modified formila such as : =NETWORKDAYS(C14-5,D14-5) I received a good result. try with start date March 18 and end date March 29 Regards, Patrick |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Working Days of Week and DUE DATE for PAYMENT | Excel Worksheet Functions | |||
| Calculate working days but change working week | Excel Discussion (Misc queries) | |||
| 5 working days of a week | Excel Discussion (Misc queries) | |||
| how to change week-offs from saturday and sundays to sunday and mo | Excel Discussion (Misc queries) | |||
| Count working days by week | Excel Worksheet Functions | |||
![Bob Phillips[_14_] is offline](https://www.excelbanter.com/images/SultanThemeVB3R/statusicon/user_offline.gif)
Threaded Mode
