You want to allow the user to be able to enter a date of only the current month, and all other dates should be restricted.

Eg.: The month is March in 2015 – You want to allow the user to enter a date only between 1st Mar 2015 and 31st Mar 2015.

Data Validation can be used to achieve this.

Follow these steps: –

  • Select the cells on which you want to apply this data validation
  • Go to Data Tab and click on Data Validation, and then..
  • In Allow, select Date
  • In Data, select Between
  • For the Start Date, put this formula
    • =DATE(YEAR(TODAY()),MONTH(TODAY()),1
  • For the End Date, put this formula
    • =DATE(YEAR(TODAY()),MONTH(TODAY()),DAY(DATE(YEAR(TODAY()),MONTH(TODAY())+1,1)-1))
Allow date of only current month date

Data Validation Settings

It’s done!

Also See:

Keep Excel-ing!