» 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:
- 422 Tax Deductions for Businesses and Self-Employed Individuals : You Get a Raise Every Time You Find a Legitimate Tax Deduction
- The Accounting Game : Basic Accounting Fresh from the Lemonade Stand
- Marketing Planning for Services
- The Analysis and Use of Financial Statements
- The Laws of Money, The Lessons of Life: Keep What You Have and Create What You Deserve
- Microsoft PowerPoint Version 2002 Step by Step
No comments have been submitted.
