Excel Data Validation

[c_marriott]

Bit of a shit post here but I'm trying to set up an excel worksheet with data validation and it won't work.

 

I have two dates (Collection and return) and it can't be any less than 3 days between them but it can't be any higher than 90 days. I've managed to set up a minimum day rule but I can't work out how to do a maximum as I can't have two rules on one cell. Any help?

 

If it helps I have a 'Total days' cell that works out the days between the Collection and return date so it does spit out a number of days.

 

Any help would be appreciated. I can attach the file if needed

[DXMember]

Bit of a shit post here but I'm trying to set up an excel worksheet with data validation and it won't work.

 

I have two dates (Collection and return) and it can't be any less than 3 days between them but it can't be any higher than 90 days. I've managed to set up a minimum day rule but I can't work out how to do a maximum as I can't have two rules on one cell. Any help?

 

If it helps I have a 'Total days' cell that works out the days between the Collection and return date so it does spit out a number of days.

 

Any help would be appreciated. I can attach the file if needed

try an AND statement betwwen them something like this:

A33-B33 > 3 AND A33-B33 < 90

where A33 and B33 are the dates

 

are you using if statements in Excel? I believe it was like this

=IF(statement;action on true;action on false)=IF(statement;IF(statement;action on true;action on false);action on false)

[Naeaes]

You can use AND to have two or more equations. It'd be possible to have the whole heap of code in once cell but you can also have each check send the output to hidden shells and use AND to combine them in some visible way.