|

# » Entering Dates Quickly

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".

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".

Rate This Tip
 1 2 3 4 5
Rating: 2.98     Views: 54701