Hi,

First of all, I know how to use Index and Match functions without any
trouble, but this new task is really giving me the troubles.
I have, for example, 12 sheets, each representing one month, and in each one
31 columns, representing each day of the month, and sum for each column.
Dates of months are set in Column 2, from B2:AF2.
Sum row is set in column 28, from B28:AF28.
G1 cell in 13th sheet represents today().
Now, on the 13th sheet, I wanted to present sum for the present day, so I
used this formula:
=INDEX(January:Decembar!2:28,January:Decembar!28:2 8,MATCH(G1,January:Decembar!2:2,0))
But, it doesn't work. It shows #ref! in row part, and #value! in column part.
What am I doing wrong?