Articles Archive

Entering dates quickly, without having to use delimiters to separate month, day, and year.

nter 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

Continue Reading