Good morning
I have the IF formula that you see below that sort of works… there are some cases where cell H18 will be Null so I don’t want “Stale” comment to be returned if the cell is Null. I don’t know what to add to what I have so it won’t count it….
Formula:
IF(H8<TODAY()-365,"Stale",IF(H14<TODAY()-365,"Stale",IF(H18<TODAY()-365,"Stale","")))
Bookmarks