| Home |
| Search |
| Today's Posts |
|
#12
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
How to make Friday as weekend instead of Sat/Sun in Workday Functi
Dear Naushad ,
I have tried following formula and it works as per your need. =A1+B1+INT((B1+A1-6)/6)-INT((B1-6)/6) H S Shastri Pl press YES if found useful. ++++++++++++++++++++++++++++++++++++++++++++++++++ ++++++ "Naushad" wrote: if in cell A1 is the no.of days and in cell B1 is the start date. How can I have workday calculated in cell c1 with Friday as weekend and saturdays & sundays as workdays. |
| 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 | |||
| Friday as weekend in Workday Function | Excel Worksheet Functions | |||
| Friday as weekend instead of Saturday & Sunday | Excel Worksheet Functions | |||
| If weekend date display previous Friday date | Excel Discussion (Misc queries) | |||
| If function for workday & weekend | Excel Worksheet Functions | |||
![HARSHAWARDHAN. S .SHASTRI[_2_] is offline](https://www.excelbanter.com/images/SultanThemeVB3R/statusicon/user_offline.gif)
Threaded Mode
