insert date

[Guest]

I need a formula that will change in my data validation list. example: I have
a list of 30 days starting with Oct. 1 to Oct. 30, tomorrow I want it to read
Oct. 2 to Oct. 31 in my Data Validation list. Can someone help me with this?

 

[Frank Kabel]

Hi
you could use the TODAY() function for this. So something like the
following in A1:
=TODAY()-30
and in A2:
=A1+1
copy this down and use this data as source for your listbox

--
Regards
Frank Kabel
Frankfurt, Germany

I need a formula that will change in my data validation list. example: I have
a list of 30 days starting with Oct. 1 to Oct. 30, tomorrow I want it to read
Oct. 2 to Oct. 31 in my Data Validation list. Can someone help me

with this?