I'm trying to create a range of dates spanning the next couple of years. I want to ultimately have a pulldown list that contains one date for the third Friday of each month. I know how to make the list if I manually type in each of these dates, but I'd like to have Excel create them for me. Seems simple enough but I can't get Excel to work with me on non-constant shifts of time like every 3rd Friday, since each month is a different number of days.
What's the trick all you Excel jockies out there?
Jonathan
What's the trick all you Excel jockies out there?
Jonathan