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