| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Validation Date
Hi
Is there anyway to validate a date to ensure that the date enetred in cell B2 is a Monday? Also how would it be coded to ensure that if a Monday was not entered then it returned a error message. Thanks |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Validation Date
I would use a combination of Formulas and Conditional formatting to do that.
Assuming your date is in Cell A1. Select A1 Format | Conditonal Formatting... | Formula is: =WEEKDAY(A1) < 2 and select a pattern In the adjacent cell B2 add the formula =IF(WEEKDAY(A1) = 2, "", "Invalid Date") -- HTH... Jim Thomlinson "housinglad" wrote: Hi Is there anyway to validate a date to ensure that the date enetred in cell B2 is a Monday? Also how would it be coded to ensure that if a Monday was not entered then it returned a error message. Thanks |
|
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Validation Date
Thanks for that, but is there a way of doing it without writing the error
message in the adjacent box? "Jim Thomlinson" wrote: I would use a combination of Formulas and Conditional formatting to do that. Assuming your date is in Cell A1. Select A1 Format | Conditonal Formatting... | Formula is: =WEEKDAY(A1) < 2 and select a pattern In the adjacent cell B2 add the formula =IF(WEEKDAY(A1) = 2, "", "Invalid Date") -- HTH... Jim Thomlinson "housinglad" wrote: Hi Is there anyway to validate a date to ensure that the date enetred in cell B2 is a Monday? Also how would it be coded to ensure that if a Monday was not entered then it returned a error message. Thanks |
|
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Validation Date
Another way would be to use
Data | Validation | Custom with a formula of =WEEKDAY(A1) = 2 You may want to add an input and or error message to help the user. -- HTH... Jim Thomlinson "housinglad" wrote: Thanks for that, but is there a way of doing it without writing the error message in the adjacent box? "Jim Thomlinson" wrote: I would use a combination of Formulas and Conditional formatting to do that. Assuming your date is in Cell A1. Select A1 Format | Conditonal Formatting... | Formula is: =WEEKDAY(A1) < 2 and select a pattern In the adjacent cell B2 add the formula =IF(WEEKDAY(A1) = 2, "", "Invalid Date") -- HTH... Jim Thomlinson "housinglad" wrote: Hi Is there anyway to validate a date to ensure that the date enetred in cell B2 is a Monday? Also how would it be coded to ensure that if a Monday was not entered then it returned a error message. Thanks |
|
#5
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Validation Date
Yeh that is alot better, brillant mate, do you have msn?
|
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| date validation | Excel Worksheet Functions | |||
| Validation on date | Excel Worksheet Functions | |||
| date validation | Excel Worksheet Functions | |||
| date validation MAYBE | Excel Discussion (Misc queries) | |||
| Date Validation - Must equal Sundays date | Excel Discussion (Misc queries) | |||
Hybrid Mode
