| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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. |
|
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
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. |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Excel 2003 FAILS, but Excel 2000 SUCCEEDS ??? | Excel Discussion (Misc queries) | |||
| How to get the Excel to calculate the exact date from a given date | Excel Worksheet Functions | |||
| Calendar Control in Excel 2000 can't display date in Excel 2003? | Excel Discussion (Misc queries) | |||
| Excel date format trouble | Excel Discussion (Misc queries) | |||
| Excel file modification date | Excel Discussion (Misc queries) | |||
Hybrid Mode
