0

Hi I was hoping you could help. I have Today() in cell A1, date in B3, and a formula in cell C3: =$A$1-B3.

I want to make cell C3 to be BLANK if cell B3 date is blank with no date.

I want to make cell D3 to be "YES" if C3>14 and "NO" if less. However, if cell C3 is blank, D3 also should be blank

Have tried in cell C3 =IF(ISBLANK(B3), "", $A$1-B8) and in cell D3 =IF(C3>14, "YES","NO").

The cell C3 does return blank however, cell D3 does not, the problem is Today() in cell A1 is returning a value which mean the cell is not empty. I checked by using =IF(ISBLANK(K8), "TRUE", "FALSE"), the answer is False.

Please kindly help

ayinla oshodi
  • 3
  • 2
  • Can you create a [reprex]? You've got `IF(ISBLANK(B3), "", $A$1-B8)` - what's with the `8`? And then `=IF(ISBLANK(K8), "TRUE", "FALSE")` - what's with the `K` and `8`? How does row 8 or column K relate to your question, which is presumably about row 3? – BigBen Mar 22 '21 at 19:51

0 Answers0