I am working with a spreadsheet that already had the following formula in it to track OVERDUE, 30 Days and 60 Days away.
Cell $V$1 has the formula =TODAY() to report the current date for comparison.
Cell K2 tracks the date entered in the cell to start annual tracking.
Formala:
=IF(K2<$V$1,"OVERDUE", IF(K2<$V$1+30,"30 Days", IF(K2<$V$1+60,"60 Days", IF(K2>$V$1+61,"-"))))
The issue I am running into is that K2 may be blank if tracking hasn't been started yet for that item.
I cannot figure out how to modify the formula that if the cell (K2) is blank, the formula would return the word "Inventory" in the cell.
I would greatly appreciate any help with this. I also recognize this may not be the best formula for this so other options would be welcome.
Bookmarks