Hi
I want to calculate 20 business days from either date a or date b using a formula. Then I want to conditionally format the cell so that if today is past the 20 business days from either date a or date b the cell turns red. I have created the list of public hols and used the workday function to calculate the 20 business days from a single but am having trouble calculating the 20 business days if Date A is blank and Date B has data and vice versa.
I have stuck a `in front of the formula so I can see what I am testing in the cell below. I keep getting error message of either too many arguments or not enough parenthesis. I've spent hours trawling through previous posts but couldn't find one that was an exact fit for my scenario.
Any pointers greatly appreciated.
Thanks
Bookmarks