Hello,
I was hoping someone could help me with the following error on my formula.
=IF(W19="Priority",NETWORKDAYS(K19,IF(X19="",TODAY(),X19)))
Where W19 is a text selector cell with a set of drop down options (priority, regular, NA)
I want the formula to find the difference between 2 dates K19 and X19 only if "Priority" is selected (in NETWORKDAYS) or between K19 and TODAYS date if X19 is BLANK.
If "regular" or "NA" is selected I want the cell to be BLANK and currently it is returning "FALSE"
Please help.
Bookmarks