Data Validation Lists

[jerm_e]

Hey!

In cell F7, I would like to have a drop down list (using data validation) that lists the following choices:

=TEXT($C$1+5, "yyyy")
=TEXT($C$1+5, "yyyy")+1
=TEXT($C$1+5, "yyyy")+2
=TEXT($C$1+5, "yyyy")+3
=TEXT($C$1+5, "yyyy")+4

Where C1 contains =Today()

But I can't seem to enter the formulas into the List text box on the data validation menu. Any help on how I can accomplish this?

Thanks!

Jerm

 

[ctrlaltdel]

Validation

Hey,

Enter the formulas in some other cells on your worksheet (say cells AA1:AA5 and then just reference them in the data validation.

Make sense?


James

 

[adulted]

Data Validation

Hi jerm_e,

In cells A1:A5 key in your formulas. Select A1:A5 and define a name like dates

With C1 is =Today()

Select F7, click Data, Validation, cange Validation Criteria Allow option to List. Change the Source to =dates

Hope this helps,
Paul

 

[jerm_e]

Working wonders. Thanks again!

Jerm