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.

=DATE("20"&RIGHT(A1,2),LEFT(A1,LEN(A1)-4),MID(A1,LEN(A1)-3,2))

This will assume all dates are in 2000 or after.

Good luck