Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
date validation
Hi
Is there a way to easily validate dates in cells? (ie June 31, 2001 should be rejected, for example) I have cells formatted dd/mm/yyyy. If I enter, say jun 20, 2001, it shows as 20/06/2001 as expected. BUT, if I accidently enter, say 31/06/2001, Excel doesn't flag the error. Is there a fix? Bri |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
date validation
When you format a cell for dates, Excel only applies that format when the
cell value IS a date. Run this formula on the celll containing 31/06/2001: (assuming it is in Cell A1): =ISNUMBER(A1) should return FALSE if it is not a number (which dates are), To restrict entries to dates, try this: Select your input cells DataValidation Allow: Date Then, set your date restrictions. Entering 31/06/2001 should now engage a warning. Does that help? *********** Regards, Ron XL2002, WinXP-Pro "Bri" wrote: Hi Is there a way to easily validate dates in cells? (ie June 31, 2001 should be rejected, for example) I have cells formatted dd/mm/yyyy. If I enter, say jun 20, 2001, it shows as 20/06/2001 as expected. BUT, if I accidently enter, say 31/06/2001, Excel doesn't flag the error. Is there a fix? Bri |
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
date validation
Check out Data/Validation. Choose Date from the Allow dropdown.
In article , "Bri" wrote: Hi Is there a way to easily validate dates in cells? (ie June 31, 2001 should be rejected, for example) I have cells formatted dd/mm/yyyy. If I enter, say jun 20, 2001, it shows as 20/06/2001 as expected. BUT, if I accidently enter, say 31/06/2001, Excel doesn't flag the error. Is there a fix? Bri |
#4
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
date validation
Thanks to both respondees!!
Bri |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Date Validation - Must equal Sundays date | Excel Discussion (Misc queries) | |||
Adding XY days to date in cells | Excel Discussion (Misc queries) | |||
Another Date issue. | Excel Worksheet Functions | |||
Date Math Problem | Excel Worksheet Functions | |||
Need help troubleshooting an array formula XLXP on Win2K | Excel Worksheet Functions |