Data Validation formula

[sammyd83]

Hi

I'd like to make a data validation with some rules, being: either a date, blank or "N/A"

I know this can be entered in the 'custom' selection on the data validation drop down list, but just not sure how to enter this formula.

Any help and assistance you can offer me would be greatly appreciated.

 

[onlyadrafter]

Hello,

can't you just put these into three cells and use LIST and refer to the three cells?

 

[Chrisdontm]

Hi

I'd like to make a data validation with some rules, being: either a date, blank or "N/A"

-------------------------------

You could try this, setup three rules, it will activate them in the order you choose them...
Just mess around with these three and see if they will help;

=IF(L11="N/A",TRUE,FALSE)

=IF(ISBLANK(L11),TRUE,FALSE)

=IF(L11>1/1/1900,TRUE,FALSE) I hope it helps ☺

<colgroup><col style="width:48pt" width="64"> </colgroup><tbody>
</tbody>