How to use the drop down date in Excel?

G

gwtreece

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.
 
D

Duke Carey

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.
 
Top