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