Validation Date

[housinglad]

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

 

[Jim Thomlinson]

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")

 

[housinglad]

Thanks for that, but is there a way of doing it without writing the error
message in the adjacent box?

 

[Jim Thomlinson]

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.

 

[housinglad]

Yeh that is alot better, brillant mate, do you have msn?