Max wrote:
One way to achieve this ..

Source data assumed in sheet: X, cols A to D, from row1 down

In another sheet: Y (say),

In A1:
=IF(X!A1="","",IF(X!A1+60<TODAY(),"",ROW()))

In B1:
=IF(ROW()COUNT($A:$A),"",INDEX(X!A:A,MATCH(SMALL( $A:$A,ROW()),$A:$A,0)))
Format B1 as date. Copy B1 to E1

Then just select A1:E1, copy down to cover the max expected extent of data
in X
(Hide away col A if desired)

Y will return the required results.
Expired lines ( 60 days old) will not show, and the rest will move up
automatically.
--
Max
Singapore
http://savefile.com/projects/236895
xdemechanik
---
wrote in message
ups.com...

Is it possible for the contents of cells in A1-B1-C1 and D1 to
automatically clear (without deleting the row) when the date in A1 is
more than 60 days old? - and - have the contents in the next cells
down, move up to the top.

In other words, this is a Pass Log and entries over 60 days old are no
longer needed.

A1, B1, C1 and D1 in the following ,will no longer be an issue in
October so those cells would clear in October and the entries currently
in A2, B2, C3 and D2 would move up one row and remain there till they
were 60 days old..... and so forth down the sheet.


A B C D

1 8/31/06 5776 Jones Smith
2 9/22/06 5778 Brown Wallace

Thanks
Johnnie


Sorry I'm such a newbie. This is how I read your suggestion using my
limited knowledge.

<Source data assumed in sheet: X, cols A to D, from row1 down
You assume sheet1 (called X here?) has entries in column A,B,C and D
from rows 1 down.

<In another sheet: Y (say),
I should open another sheet - like sheet2?

<In A1: =IF(X!A1="","",IF(X!A1+60<TODAY(),"",ROW()))
I should paste that formula in cell A1, of sheet2.

<In B1:
=IF(ROW()COUNT($A:$A),"",INDEX(X!A:A,MATCH(SMALL( $A:$A,ROW()),$A:$A,0)))
I should paste that formula in cell B1 of sheet2.

<Format B1 as date. Copy B1 to E1
I should right click on B1, choose Format Cells and Number/Date. Then
copy B1 to cell E1.

<Then just select A1:E1, copy down to cover the max expected extent of
data
in X
I'm not sure about this part - what to copy down.

Thanks
Johnnie