on a data sheet all data is imputed - sheet 1
I have a range of cells ie a7 to a2028 with dates in them
next range of cells b7 to b2028 has either the letter s or c in them
next range of cells c7 to c2028 has numbers in them

I want to have another sheet (sheet 2) that takes information from todays
date and either s or c in column b

ie if a1 to a2028 equals march 26,2008 and b1 to b2028 equals c then take
the value in column c that is in the same row as the criteria met above

I tried using the below formula but get 0 for a response

=IF(AND('Ser Data'!A7:A2120=TODAY(),'Ser Data'!B7:B2120="s"),'Ser
Data'!C7:C2120,0)

Please help