Drop-down list of dates from the last 2 weeks

Hello,

I want to make a drop down list in excel that displays to me the last two weeks from the date the excel sheet is calculated (so generally when the sheet is opened)

I have a list from 9/1/07 till 8/30/08 and it Currently displaying all the dates in between

I imagine this is a conditional formatting issue where (date <= TODAY()) and (date >= SOMETHING).

What would that something be? I cant do TODAY(-5) to represent 5 days ago, as I imagined but I thought Id try.

Any Suggestions? Is there an easier way? I want it so that I can adjust it in case I want 3 or 4 weeks.

Thanks you

Please view the file attached and let me know if it is what you need.

BigBas,

Thats it! Thank you for the quick response. Ill be reading it over to make sure I will fully understand it.

Thanks again.

Glad I could help.

Feel free to post any follow up questions that you may have.

I guess the last thing I am looking for is how to conditionally format the range of dates to certain colors. Lets say I made a date set for this past week, it would be green, date set that is 2 weeks back would be orange etc.

The drop down list is used on another sheet.

Thanks again.