| Home |
| Search |
| Today's Posts |
|
#4
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Friday as weekend in Workday Function
Instead of
=WORKDAY(A1,B1) try =WORKDAY(A1+1,B1)-1 where A1 contains the Start Date and B1 the Number of Days... Not sure how this will work if you add Holidays and the holiday falls on Fri or Sun... Can you pl. test and let us know? "Naushad" wrote: How can i change weekend from saturday & Sunday to Friday for a workday function |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| How do I set NETWORKDAYS to regard friday and saturday as weekend | Excel Worksheet Functions | |||
| If weekend date display previous Friday date | Excel Discussion (Misc queries) | |||
| Using WORKDAY function | Excel Worksheet Functions | |||
| Workday function | Excel Discussion (Misc queries) | |||
| If function for workday & weekend | Excel Worksheet Functions | |||
![Sheeloo[_3_] is offline](https://www.excelbanter.com/images/SultanThemeVB3R/statusicon/user_offline.gif)
Threaded Mode
