Thread: Counting out 10 days from today and then adjusting to the following business day
View Single Post
 
Old 05-19-2018, 08:47 AM
ArviLaanemets ArviLaanemets is offline Windows 8 Office 2016
Expert
  
Join Date: May 2017
Posts: 949
ArviLaanemets has a brilliant futureArviLaanemets has a brilliant futureArviLaanemets has a brilliant futureArviLaanemets has a brilliant futureArviLaanemets has a brilliant futureArviLaanemets has a brilliant futureArviLaanemets has a brilliant futureArviLaanemets has a brilliant futureArviLaanemets has a brilliant futureArviLaanemets has a brilliant futureArviLaanemets has a brilliant future
Default
USE WEEKDAY() with ISO weekday numbers. Then you can use formula (on fly)
Code:
=E6 + (8 - WEEKDAY(E6,2))*(WEEKDAY(E6,2) > 5)
Last edited by ArviLaanemets; 05-19-2018 at 04:48 PM.
Reply With Quote