List of Dates In DropDown Starting From Today()

[rich_cirillo]

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

[Excel Fox]

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.

[Kevin@Radstock]

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)

[rich_cirillo]

Thank you

How does this formula work please: =OFFSET($V$1,0,0,COUNTA($V:$V),1)

[Kevin@Radstock]

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 (http://blog.contextures.com/archives/2011/01/27/30-excel-functions-in-30-days-26-offset/) function.

Kevin

[snb]

I think this suffices:


in V1:

=TODAY()+ROW(1:$21)