What formula would transpose stale dated cells?
 

I am trying to have stale dated cells copied into blank cells but cannot seem
to find a formula that might do that. Any character in the new cell would be
fine as long as it highlights the old dates.

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.

What formula would transpose stale dated cells?
 

Hi Debbie,

You could use conditional formatting with formula is =A1<TODAY().
That way your dates will be automatically highlighted as soon as they
are past.

HTH
Martin

"Debbie" wrote:

I am trying to have stale dated cells copied into blank cells but cannot seem
to find a formula that might do that. Any character in the new cell would be
fine as long as it highlights the old dates.