dropdown list for dates

[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

 

[CodeNinja]

Create a hidden list... on another sheet, or on the same sheet, use a formula to add to the day for 21 cells =A3+rows(a$4:a4) and copy down so you have 21 cells with dates... then either name a range and use that as your data validation or just use the list as your data validation.

 

[rich_cirillo]

I will try .. thank you