Intersection of Week
 

I have a worksheet set up with dates(merged cells) and departments(tw
separate cells) on the top and names on the side like this:

06/01-03 06/04-10 06/11-17
Ship Main Ship Main Ship Main
Bob
Jim
Lisa
Bill

Now I have another sheet that someone puts in the date and the name an
the department, and hours worked in that department.

My question is, how do I (1) Get the date in the right column if i
falls in or on the start or end date, then

(2)how do I get it to be in the shipping or maintenance column

--
Message posted from http://www.ExcelForum.com