How to use the drop down date in Excel?

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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.
 
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.
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Date Range Drop Down Menu 1
Drop Down with dynamic named range offsheet source list 14
Dependent drop down dynamic range formula, off sheet. 7
drop down box code 2
Formatted cell column in drop down list 1
Created invoices in Excel - not working in Drive 1
data validation fonts differ in drop down box 1
Drop Down Calendar in Excel with a Default Value 1

Back
Top