MrExcel Publishing
Your One Stop for Excel Tips & Solutions

saving keystrokes entering dates in Excel

Posted by Ed on July 30, 2001 6:07 AM

Is there a way to enter dates in a cell like
010101 (jan 01 2001)
wihtout the / slashes to save 2 key strokes per cell ?

Posted by Mark W. on July 30, 2001 6:27 AM

You can save key strokes by not entering the year.
Since it defaults to the current year you can enter
1/1, 1/15, etc.

Posted by IML on July 30, 2001 9:42 AM

You could try this not fully tested formula and copy it down.
This assume your first entry is in A1.


This will assume all dates are in 2000 or after.

Good luck