I have a spreadsheet that has a column that contains the date a particular
item was shipped.

I want to be able to identify (not with colours) those rows in which todays
date minus the date in the cell is greater then 5 days. If so, I want to
enter the value "Yes" in another column (title of column is Overdue because
its been greater then 5 days).

I have used: =IF(TODAY()-AI45,"Yes","")

The problem is, if the date column is blank, it still returns a Yes value.

How can I avoid this? I want it to either remain blank, or state No.

Help!