Output client name based on date...
 

Here is what I have...

I need to cross reference a column against a date which is in serial
format. In a customized Excel calendar on another tab, I need to cross
reference data to another tab. Example: In one cell of the calendar
for the date 9/7/06 (38967), I would like to have any client activity
listed on this date. Keep in mind there might be multiple occurrences
that happen on that day (there a total of six cells in each date on the
calendar). The serial values for September are 38961 (9/1) to 38990
(9/30). I would use the actual date but other formulas throughout this
book reference the serial version so I decided to stay with the current
norm.


client 1 38961
client 2 38962
client 3 38963
client 4 38964
client 5 38967
client 6 38966
client 7 38967
client 8 38990


Thanks for the help