View Single Post
 
Old 11-17-2017, 11:07 AM
ArviLaanemets ArviLaanemets is offline Windows 8 Office 2016
Expert
 
Join Date: May 2017
Posts: 869
ArviLaanemets has much to be proud ofArviLaanemets has much to be proud ofArviLaanemets has much to be proud ofArviLaanemets has much to be proud ofArviLaanemets has much to be proud ofArviLaanemets has much to be proud ofArviLaanemets has much to be proud ofArviLaanemets has much to be proud ofArviLaanemets has much to be proud of
Default

In attached file is a possible solution.

NB! It's better to leave the Weekday() function with European format - much easier for calculations when weekends are days 6 and 7.

PS. Without additional sheet it will be nearly impossible. You must move the date away from weekend, then move away from holiday when date happens to be one, then again you have to check that new dates aren't weekends and when , then move the date, then you have anew to check for holidays, etc.
Attached Files
File Type: xlsx FutureWorkday.xlsx (31.8 KB, 16 views)
Reply With Quote