Hi,
I have a column K in a sheet of mine that contains either blanks or dates.
I would like work out how to return "No date" if the cell in column K is blank, but if its not then work out whether the date is within two weeks of today or not.
That second part I can use =IF(K2<=TODAY()-14,"Move","Stay") works perfectly but I cant work out how to get the formula to say "No date" if any cell in column K is blank.
Google isnt helping much either.
Thanks in advance.
Bookmarks