Match calendar days and return value below

[kasper]

I have created a monthly calendar that I want to use to to manage lieu time (I've already figured out sick, vacation days). What I think I need is a formula that will match a column of dates with the ones in each monthly calendar then returns the lieu time value 2 cells below the date. So in the setup below I have a column of 365 dates that I want to match up with the corresponding dates in the calendars laid out horizontally across the worksheet and then return the manually entered value 2 rows below that date. For instance match January 21 and return 30.
Any ideas?

Excel 2010

	H	I	J	K	L	M	N
5	January
6	Sunday	Monday	Tuesday	Wednesday	Thursday	Friday	Saturday
7	20	21	22	23	24	25	26
8
9	27	28	29	30	31	1	2
10						New Year's Day
11
12	3	4	5	6	7	8	9
13
14
15	10	11	12	13	14	15	16
16
17
18	17	18	19	20	21	22	23
19
20					30
21	24	25	26	27	28	29	30
22
23
24	31	1	2	3	4	5	6
25

<colgroup><col style="width: 25pxpx"><col><col><col><col><col><col><col></colgroup><thead>
</thead><tbody>
</tbody>

Calendar template​

Worksheet Formulas Cell Formula H7 =N$4+'Calendar template'!$K$37+$F$7*7+$H$3 I7 =N$4+'Calendar template'!$K$37+$F$7*7+$I$3 J7 =N$4+'Calendar template'!$K$37+$F$7*7+$J$3 K7 =N$4+'Calendar template'!$K$37+$F$7*7+$K$3 L7 =N$4+'Calendar template'!$K$37+$F$7*7+$L$3 M7 =N$4+'Calendar template'!$K$37+$F$7*7+$M$3 N7 =N$4+'Calendar template'!$K$37+$F$7*7+$N$3 H8 =IF(AND(H7>=$N$4,H7<$Y$4),IFERROR(INDEX(Holidays,MATCH($H$5&DAY(H7),Dates,0)),""),"") I8 =IF(AND(I7>=$N$4,I7<$Y$4),IFERROR(INDEX(Holidays,MATCH($H$5&DAY(I7),Dates,0)),""),"") J8 =IF(AND(J7>=$N$4,J7<$Y$4),IFERROR(INDEX(Holidays,MATCH($H$5&DAY(J7),Dates,0)),""),"") K8 =IF(AND(K7>=$N$4,K7<$Y$4),IFERROR(INDEX(Holidays,MATCH($H$5&DAY(K7),Dates,0)),""),"") L8 =IF(AND(L7>=$N$4,L7<$Y$4),IFERROR(INDEX(Holidays,MATCH($H$5&DAY(L7),Dates,0)),""),"") M8 =IF(AND(M7>=$N$4,M7<$Y$4),IFERROR(INDEX(Holidays,MATCH($H$5&DAY(M7),Dates,0)),""),"") N8 =IF(AND(N7>=$N$4,N7<$Y$4),IFERROR(INDEX(Holidays,MATCH($H$5&DAY(N7),Dates,0)),""),"") <thead> </thead><tbody> </tbody>

<tbody>
</tbody>

Workbook Defined Names Name Refers To Dates ='Calendar template'!$N$37:$N$47 Holidays ='Calendar template'!$O$37:$O$47 <thead> </thead><tbody> </tbody>

<tbody>
</tbody>

 

[kasper]

Does anyone have any ideas at all on this?