Calender as validation list?

  • Thread starter Thread starter RexP
  • Start date Start date
R

RexP

Is there any way to have a validation menu that looks like (or actually
is) a calender? I've created a validation table that simply lists a
series of dates, but that is a little cumbersome for people to scroll
through looking for a specific date, and its impossible to distinguish
weekends and holidays.

Thanks in advance.

Rex
 
Hi Rex!

You could use three cell entry for Day, Month, Year?

Year entry could be a validated four digit entry. Day and month could
be validated lists.

A cell brings together the input using the DATE function with the date
constructed from the input.

You can test for invalid date inputs (e.g. 30-Feb-1004) because if the
month calculated using DATE <> month input, then Excel has rolled over
the excess days.

You can also test input for Saturday and Sunday entries using the
WEEKDAY function.

Similarly you can test for the date being in a list of holidays.

--
Regards
Norman Harker MVP (Excel)
Sydney, Australia
(e-mail address removed)
Excel and Word Function Lists (Classifications, Syntax and Arguments)
available free to good homes.
 
Back
Top