Workday (use preceeding workday)
Posted on 2014-11-07
What do I need to change in the below to return the workday before and not the next workday? I could need 2 days before and not only 1 day. I dont know if it's as simple as changing a sign on the -1 and if you want 2 days before then change the 1 to a 2.
Here is the formula with an explanation from another expert (Barry Houdini)
<When the original formula gives you a weekend date that will jump to the next working day