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?
 

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

--
Max
Singapore
http://savefile.com/projects/236895
xdemechanik
---
"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.