ExcelBanter - Skip weekends

ExcelBanter (https://www.excelbanter.com/)

- Excel Worksheet Functions (https://www.excelbanter.com/excel-worksheet-functions/)

- - Skip weekends (https://www.excelbanter.com/excel-worksheet-functions/245172-skip-weekends.html)

rhhince[_2_]

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.

Herbert Seidenberg

Skip weekends

Excel 2007
Exclude odd weekend/time block
from days/hours calculations.
http://www.mediafire.com/file/twnumm...10_11_09a.xlsx

All times are GMT +1. The time now is 07:59 AM.