» Quickly Typing Dates into Cells
Typing a large amount of data into cells can be tiring, especially if it includes a series of dates.
Type the day (serial number only) into cell A1 and add the following formula to insert the month and year into cell B1:
=DATE (YEAR(TODAY()), MONTH(TODAY()), A1)
Type a full number in the cell and change it to a date by using the following formula:
For example, type 122203, the result is 12/22/03.
|Screenshot // Quickly Typing Dates into Cells |