Hi,
I am trying to get a cell (X9) to return either
a date thats +14days from another cells (V9) date if another cell (W9) has "yes" value
a blank cell if another cell (V9) is blank
an "N/A" if another cell (W9) has a "No" Value
Ive tried this but to no good:
=IF(V9="","",V9+14),IF(AND(V9=>01/01/1986,W9="Yes"),V9+14,IF(W9="No","N/A")
Any help would be much appreciated
Thanks
Jake
Bookmarks