Excel Tips: 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\”.
🔥0 Post views
