What formula would transpose stale dated cells?
Hi,
Not quite sure what you're after, but I'll have a go as much as I understand
the question.
If your stale date (does that mean a date older than today?) is in A2,
then in B2 put =IF(A2<TODAY(),"Stale","")
If you really want the old date in the new cell, then:
=IF(A2<TODAY(),A2,"")
For the 2nd option, make sure B2 is has a date format.
Regards - Dave.
|