| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
date and time [skipping weekends]
I have a number in a cell that represents days. I wish to add these
days to the current date and time, which is easy to do. =NOW()+A3 I format it into time displaying date and time. How can I automatically skip the weekend from Friday 16:00 to Sunday 16:00 which is 48 hours in the addition? |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Date/Time Difference Excluding Weekends & Holidays | Excel Worksheet Functions | |||
| subtracting date and time formats excluding weekends | Excel Worksheet Functions | |||
| Subtracting Dates to get total time work time excluding weekends | Excel Discussion (Misc queries) | |||
| add time with out weekends | Excel Discussion (Misc queries) | |||
| How do I set up a clumn of days, skipping weekends? | Excel Worksheet Functions | |||
![rhhince[_2_] is offline](https://www.excelbanter.com/images/SultanThemeVB3R/statusicon/user_offline.gif)
Threaded Mode
