» Entering Dates Quickly
CATEGORY - Excel Date & Time Formulas
VERSION - All Microsoft Excel Versions
Entering dates quickly, without having to use delimiters to separate month, day, and year.
Solution 1:
Enter only the "day" part of the date and complete it by using the DATE, YEAR, TODAY, and MONTH functions in the following formula:
=DATE(YEAR(TODAY()),MONTH(TODAY()),A2)
Thus, on entering "5", the formula will automatically create a date representing the 5th of the current month in the current year.
Solution 2:
Enter the entire date, without delimiters, and use the DATEVALUE, LEFT, MID, and RIGHT functions as shown in the following formula to convert it to a proper date:
=DATEVALUE(LEFT(D2,2)&"/"&MID(D2,3,2)&"/"&RIGHT(D2,2))
Thus, on entering "060705", the above formula will return "06/07/05".
Problem:
Entering dates quickly, without having to use delimiters to separate month, day, and year.
Solution 1:
Enter only the "day" part of the date and complete it by using the DATE, YEAR, TODAY, and MONTH functions in the following formula:
=DATE(YEAR(TODAY()),MONTH(TODAY()),A2)
Thus, on entering "5", the formula will automatically create a date representing the 5th of the current month in the current year.
Solution 2:
Enter the entire date, without delimiters, and use the DATEVALUE, LEFT, MID, and RIGHT functions as shown in the following formula to convert it to a proper date:
=DATEVALUE(LEFT(D2,2)&"/"&MID(D2,3,2)&"/"&RIGHT(D2,2))
Thus, on entering "060705", the above formula will return "06/07/05".
Book Store:
Recommended Books:
- Microsoft Office Xp: Advanced Concepts and Techniques: Word 2002, Excel 2002, Access 2002, Powerpoint 2002
- Definitive Guide to Excel VBA
- Keys to Reading an Annual Report (Barron's Business Keys)
- Getting to Yes: Negotiating Agreement Without Giving In
- The Intelligent Investor: The Definitive Book On Value Investing, Revised Edition
- MP Managerial Accounting w/ Topic Tackler, Net Tutor, & PowerWeb
shawna
Is there a way for the date to automatically update whenever the template is opened?
Entering Dates
Beverly Pastizzo
When I enter the date 10-Sep in my date column and go top the next cell, the date turn into a five digit number that seems to have nothing to do with a date. What is wrong? I am new to Excel.
entering dates quickly
ajay
IF I CREATE 31 DIFFERENT WORKSHEET AND WANT TO WRITE DATES ON SAME CELL OF EVERY WORKSHET IS SOLUTION IS =TODAY(),BUT IF I WANT DIFFERENT DATES ON EACH WORKSHEET AS SERIAL IE OON SHEET 1 1MAY, SHEET 2 2MAY, SHEET3 3MAY...........
WHAT I NEED TO DO
THANK YOU
convert text '12/06/1985' in proper dates
shiva
i want to convert this text dates into proper date so can performed mat cal on that data
Automatic update of date/time when clicking a cell
D.L.
I would like to be able to click on a cell to automatically populate it w/ the current time (or date). How do I do this? Can I use formulas, or are Macros involved (I am not experienced w/ Macros).
