What formula would transpose stale dated cells?

  • Thread starter Thread starter Debbie
  • Start date Start date
D

Debbie

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.
 
Just venturing some thoughts for you (you've had no responses so far)

Assuming the dates are listed in A2 down
you could apply conditional formatting by selecting col A,
then place this in the "Formula Is" box:
=AND(ISNUMBER(A1),A1<TODAY())
Then just format the fill color, etc to taste
This will highlight all cells in col A with dates earlier than today

You could also place the same formula in an adjacent col,
say in E2: =AND(ISNUMBER(A1),A1<TODAY())
then copy E2 down as far as required
Then apply autofilter on col E, choose: TRUE
to filter out all lines with dates earlier than today
 
Back
Top