Data validation

[Gareth]

I have a number of columns on my worksheet which need validation.

Some of them only have one validation check but others are involved in 2 or
3 checks.

Can I do this using data validation?

I tried selecting the 'Custom' type and entering a formula.

For example, I have a 'date of birth' column and a 'date of first calf'
column. The values entered into these columns must be >= 01/01/1980

I set up these validations quite quickly but then found that the 'date of
first calf' cannot be before the 'date of birth', it is here where I get
stuck.

Can anyone help with setting up validation for 'date of first calf'

Date of birth - column D
Date of first calf - column H

Thanks in advance.

Gareth

 

[Gareth]

Bob

You are correct, physically it is not possible. However, it may be possible
for users to enter an incorrect date in either column which would lead this
to be the case.

The validation check would hopefully stop them entering incorrect dates.

This is what I want to check calving date for:
1. Date has to be >= 01/07/1996
2. Cannot have a calving date if animal is male (sex = column E)
3. Calving date cannot be before date of birth (dob = column D - validation
is >= 01/01/1980)
4. Calving date cannot be within 12 months of dob

I hve tried formulae in the 'Custom' validation type, but with no luck.

Hope you can help.

Gareth