Excel’s EOMONTH() function returns the last day in a month, and it handles leap years. Most users will use it to determine maturity dates, due dates, and even forecasting. Its syntax is simple ...

Excel's data validation ... way Using literal dates is the simplest way to create a validation control that limits input to a range of dates. You just enter the first and last acceptable dates ...