staff schedule in excel

I am attempting to build...or reinvent the wheel, a scheduling spread*** in
excel.
My parameters are
Employee Name
Date of the Month
Date of the Week
Days
Eve
Nights
I would like to be able to input a persons name and state are they
aviablable to work a particular day on a particular shift. I have been having
no luck with filters or reports.

A B C D E
F
Name Date Dayoftheweek Day EVE
Night
Bill 22May Sun N Y
N
Mary 23May Mon Y N
N

I would like to have a report that would then filter out the day, the
person, and the shift avialable.

Any thoughts?
Lonny


.