Dates

[robertpeterson]

How do I setup Excel 2000 to automatically display the next date after I hit enter in a spreadsheet?

 

[Juan Pablo González]

Mhmm, not sure I understand what you need. After you press Enter, "the next date" appears ? what is that ?

 

[Mark W.]

On 2002-03-28 09:43, robertpeterson wrote:
How do I setup Excel 2000 to automatically display the next date after I hit enter in a spreadsheet?

If you're entering a date in cell A1 enter =A1+1 in cell A2 to display the next date.