Dates

robertpeterson · Mar 28th, 2002, 10:43 AM

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

Juan Pablo González · Mar 28th, 2002, 10:45 AM

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

Mark W. · Mar 28th, 2002, 12:00 PM

Quote:

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.

Mar 28th, 2002, 10:45 AM	#2
Juan Pablo González MrExcel MVP Join Date: Feb 2002 Location: Bogota, Colombia Posts: 11,927	Mhmm, not sure I understand what you need. After you press Enter, "the next date" appears ? what is that ? __________________ Regards, Juan Pablo González http://www.juanpg.com

Thread Tools
Show Printable Version Email this Page
Display Modes
Linear Mode Switch to Hybrid Mode Switch to Threaded Mode

Mar 28th, 2002, 10:43 AM	#1
robertpeterson New Member Join Date: Mar 2002 Location: Eveleth, MN Posts: 1	How do I setup Excel 2000 to automatically display the next date after I hit enter in a spreadsheet?