Thread: Skip weekends
View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
rhhince[_2_] rhhince[_2_] is offline
external usenet poster
 
Posts: 48
Default 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.