Hello
In cell A3 i need a formula for todays date....would i use = Today() as best option
In cells D7 & G7 how can i make dropdown list with dates starting with Todays date + 21 days.The dropdown list will always have 21 days of advancing dates and always starting with todays date.I could have the dates listed for Dropdown list in sheet1 and the results will be displayed in sheet2
Thanks
Rich
Excel 2010
Why don't you just use the formula Today() in your Sheet1, for example, in A1, and use formula A2= A1+1 and drag down till A21. That will give you a list of the 21 dates including today.
A dream is not something you see when you are asleep, but something you strive for when you are awake.
It's usually a bad idea to say that something can't be done.
The difference between dream and aim, is that one requires soundless sleep to see and the other requires sleepless efforts to achieve
Join us at Facebook
Hi rich_cirillo
You could use data validation. Create a list in your sheet say in column V, in V1 & copy down:
=TODAY()+21*ROW()-21
Data Validation:
=OFFSET($V$1,0,0,COUNTA($V:$V),1)
Thank you
How does this formula work please: =OFFSET($V$1,0,0,COUNTA($V:$V),1)
Hi rich_cirillo
The COUNTA returns the returns the number of cells that are not empty. Then returning that to the OFFSET function for the Height.
See the link on the OFFSET function.
Kevin
I think this suffices:
in V1:
PHP Code:=TODAY()+ROW(1:$21)
Posting Permissions
Reply With Quote
Bookmarks