I have a cell which has data validation applied.

It is validated to only allow a certain range of dates, in this case every
Friday this year. This range is manually set at the beginning of the year so
that users can only see this years dates.

My question is:

Is there some way I can add in a formula to the data validation source part
to automatically adjust the values that are shown in the drop down list?

What I need is a validation formula for the list which would show all the
dates that ended with 2008.

Does that make sense?

Anybody have a solution to this?


--
RMcA

For the cheats among us
http://www.gamefaqs.com/