I am trying to build a formula in excel that will compare two dates.
I am using =NETWORKDAYS formula to calculate the number of days in between, and that is working great.
My problem is, in Cell C1, I am entering a date of arrival. What I need is:
If the arrival date is a workday, then it...