How to use the drop down date in Excel?
 

I know how to use the drop down for data. There is an option for date but I
can't seem to get it to work. Help.

How to use the drop down date in Excel?
 

The date option is for Validation, not for a list. You can specify whether
the entered date must be between 2 specified dates, or earlier/later than a
specified date, etc.

If you want to use a dropdown list for dates, create the list of permissible
dates, then set validation for the entry cell to a list and point to the list
of dates you've created.

"gwtreece" wrote:

I know how to use the drop down for data. There is an option for date but I
can't seem to get it to work. Help.