=IF(E7="YES","DONE",=WORKDAY(Q7,$E$4,'Built Time Line.xls'!HOLIDAYS))
if an adjacent cell E7 has YES value then say DONE, if it is NO (or something else) then run the =workday formula.
Thanks
Alan
=IF(E7="YES","DONE",=WORKDAY(Q7,$E$4,'Built Time Line.xls'!HOLIDAYS))
if an adjacent cell E7 has YES value then say DONE, if it is NO (or something else) then run the =workday formula.
Thanks
Alan
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks