insert date

K

Khamsta

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

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

Khamsta said:
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
Click to expand...
with this?
 
Top