Use the DATE and WEEKDAY functions as shown in the following formula:
=DATE(C2,1,3)-WEEKDAY(DATE(C2,1,3),1)+7*(B2-1)+A2

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 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\”.

=DATE(YEAR(TODAY()),MONTH(TODAY())+num_mths,0) where num_mths = 0 for the end of month for the current month and num_mths = 1 for the end of the month for the next month, etc.
1. Tried the formula if num_months = 0, it gives the end date for the prev

Using the RAND function in the following formula:
=INDEX(A2:A7,ROUND(RAND()*COUNTA(A2:A7),0))
The value returned by the formula will change with each recalculation (F9).