Date and category lookup

S

Soccer boy

I have a spreadsheet that is divided into 4 sections:
- Period 1 - Jan 1-Mar 31
- Period 2 - Apr 1 - Jun 30
- Period 3 - Jul 1 - Sep 30
- Period 4 - Oct 1 - Dec 31
Now each of these sections is broken down into 3 subcatergories
- Mon - Fri
- Saturday
- Sunday
and each of these is broken down into 3 catergories
- Base hours
- Intermediate hours
- Peak hours
What i want my formula to do is to be able to lookup what the base hours are
for a random date that i put in. For example if i want the put in May 9 2009
(which is a Saturday), it would give me the base hours for a Saturday in
Period 2.
Can you please help me
 
Top