| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Validation ... (Days 01-09 only)
Excel2003 ... Validation?
Cell format is mm/dd/yy ... I wish to allow any Month, Any Year ... as long as the day is from 01-09 only ... Can a Formula in Validation do this ... & ... If so, what would that formula be? Thanks ... Kha |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Validation ... (Days 01-09 only)
=DAY(A1)<10
-- --- HTH Bob (change the xxxx to gmail if mailing direct) "Ken" wrote in message ... Excel2003 ... Validation? Cell format is mm/dd/yy ... I wish to allow any Month, Any Year ... as long as the day is from 01-09 only ... Can a Formula in Validation do this ... & ... If so, what would that formula be? Thanks ... Kha |
|
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Validation ... (Days 01-09 only)
Try this:
for a data validation in Cell A1.... Select A1 From the Excel main menu: <data<validation Allow: Custom Formula: =DAY(A1)<10 Is that something you can work with? *********** Regards, Ron XL2002, WinXP "Ken" wrote: Excel2003 ... Validation? Cell format is mm/dd/yy ... I wish to allow any Month, Any Year ... as long as the day is from 01-09 only ... Can a Formula in Validation do this ... & ... If so, what would that formula be? Thanks ... Kha |
|
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Validation ... (Days 01-09 only)
Bob / Ron ...
That was easy ... Thanks ... Kha "Ron Coderre" wrote: Try this: for a data validation in Cell A1.... Select A1 From the Excel main menu: <data<validation Allow: Custom Formula: =DAY(A1)<10 Is that something you can work with? *********** Regards, Ron XL2002, WinXP "Ken" wrote: Excel2003 ... Validation? Cell format is mm/dd/yy ... I wish to allow any Month, Any Year ... as long as the day is from 01-09 only ... Can a Formula in Validation do this ... & ... If so, what would that formula be? Thanks ... Kha |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| My discovery on adding months and days to a date! | Excel Worksheet Functions | |||
| days moinths and years problem | Excel Discussion (Misc queries) | |||
| Please Help With Days Elapsed And Days Remaining Calculation | Excel Worksheet Functions | |||
| Data validation with hyperlinks | Excel Worksheet Functions | |||
| Data Validation Window? | Excel Discussion (Misc queries) | |||
Linear Mode
