My formula is just the long way of doing things. It checks if WORKDAY.INTL result is Thursday using WEEKDAY() function and if true, then looks for next workday.
Use JohnTopley's formula.
C2:
=WORKDAY.INTL(A2,1,"0001110",$G$2:$G$14)
My formula is just the long way of doing things. It checks if WORKDAY.INTL result is Thursday using WEEKDAY() function and if true, then looks for next workday.
Use JohnTopley's formula.
C2:
=WORKDAY.INTL(A2,1,"0001110",$G$2:$G$14)
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks