» Quickly Typing Dates into Cells
CATEGORY - Excel Editing
VERSION - All Microsoft Excel Versions
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:
=DATEVALUE(LEFT(A1,2)&"/"&MID(A1,3,2)&"/"
&RIGHT(A1,2))
For example, type 122203, the result is 12/22/03.
Book Store:
Recommended Books:
- The New Financial Order: Risk in the Twenty-First Century
- Monte Carlo Methods in Finance
- The 22 Immutable Laws of Marketing : Exposed and Explained by the World's Two
- How to Pay Zero Taxes (Annual)
- Special Edition Using Microsoft Outlook 2002
- Who Moved My Cheese? An Amazing Way to Deal with Change in Your Work and in Your Life
No comments have been submitted.
