In Excel 97/SR-1, how can I set a day or date in a cell, and have the other
cell track the other and in another cell, sequentially increment a number ...
i.e.:

Page 1
Date: 29 September 2005
Day: Thursday
Number: 6899

Page 2
Date: 30 September 2005
Day: Friday
Number: 6900

Page 3
Date: 01 October 2005
Day: Saturday
Number: 6901

Thank you...-