Hello @All.
It's been a while that I use Excel but this issue is actually more for SharePoint but it uses most of Excel's functions.
So SharePoint doesn't have a function called WORKDAY so I need to find the day which corresponds to the selected workday. I am able to go forward and figure out the correct workday, but when I go backwards from last work day it doesn't seem to co-operate with me. For instance, if I select "WD-2" my initial beginning of the month is "5/1/2020" and my expected WD-2 date should be "5/27/2020". If I select "WD-4" my expected result is "5/25/2020".
I've attached an excel file (as the formula is rather long) with two key cells highlighted. Any help would be greatly appreciated!
Bookmarks