View Single Post
 
Old 05-21-2018, 01:11 AM
ArviLaanemets ArviLaanemets is offline Windows 8 Office 2016
Expert
 
Join Date: May 2017
Posts: 932
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

WORKDAY() is a bit tricky function. It is logical to assume, that when you want to move the date only when it falls on weekend, and otherwise to let it unchanged, the 2nd parameter will be 0. Forget logic there - with 0 as parameter you get same date back - workday or not. Instead you have to use
Code:
=WORKDAY(E6-1,1)
Reply With Quote