Calender as validation list?

[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

 

[Norman Harker]

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.