| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Skip weekends
I have a date in cell A1, Wed 10/07/09 18:00 and I wish to add 3 days
to it, but skip the weekend that I define as Friday at 16:00 to Sunday at 17:00, Normally, I would put =A1+3. That would give me Sat 10/10/09 18:00. How would I do that? I should end up with Monday 10/11/09 19:00, 2 days and 1 hour added on. |
|
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Skip weekends
Excel 2007
Exclude odd weekend/time block from days/hours calculations. http://www.mediafire.com/file/twnumm...10_11_09a.xlsx |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Date - I would like to skip weekends in a date range | Excel Worksheet Functions | |||
| Skip Weekends in date | Excel Worksheet Functions | |||
| Subtracting dates to get hours... but I want to skip weekends | Excel Discussion (Misc queries) | |||
| how can I skip weekends in excel? | Excel Worksheet Functions | |||
| Formula to make Excel count business days/skip weekends? | Excel Worksheet Functions | |||
![rhhince[_2_] is offline](https://www.excelbanter.com/images/SultanThemeVB3R/statusicon/user_offline.gif)
Linear Mode
