Steve,

It would be better if you re-designed your workbook using database style
entries - one entry per row, with names in column A, starting date of the
time off in column B, and the end date of the time off in column C. Repeat
the name for every non-contiguous date requested off.

Then when you want to know who has time off for a specific date, filter
your list based on column B using custom "less than or equal to" and the
date of interest, and column C with custom "greater than or equal to" and
the date of interest. Then your names in column A will only show those with
that date off. You can then also look at blocks of time usiing filters.
The formula that you would need to use could be written, but it would be
complicated to both write and maintain.

HTH,
Bernie
MS Excel MVP


"AZSteve" wrote in message
...
"Time-off Calendar" is Excel workbook with 12 worksheets, Jan, Feb, Mar,
etc.
Each is set up like a calendar with 7 columns (days of week) across and
usually 5 weeks down, where first and last rows may be partially filled
like
a typical calendar.

But days aren't single cells - top cell for each day has number (date),
and
about nine cells below it to enter time-off requests (one request per
cell,
as text). Top cell showing date is actual date number formated as "d" so
only the day number shows.

In workbook ZZZ (ideally Excel 2003) I want to be able to enter the date
and
have all requests for that date in "Time-Off Calendar" workbook to be
imported, one line for each entry under that date.

I have used the match function for a less-complicated situation - only one
worksheet in the other workbook contains the data I need. But here I need
to
choose both the correct worksheet and the correct day in the other
workbook
to be able to get the ten cells below with that day's requests. Or, since
each date number is unique, can I get what I want by searching the whole
Time-Off Calendar workbook? I don't want to have to set up 365 ranges
across
the 12 worksheets.

Help please.