Hi,

Im wondering if it is possible to have a formula within the Validation drop down list that will display a list a months. Next to each month has a date range (from - to). Is there a lookup/if function that would include that month if it is over a certain date

Example:

January - 02/01/2011 - 31/01/2011
February - 01/02/2011 - 28/02/2011

Today is 30th Jan so the dropdown will only display "January"

Any help would be much appreciated
Thanks,