formula criteria

[smithrd6]

=SUMIF('215Open'!A:A,"<3/18/2011",'215Open'!B:B)


This formula works fine; however, when I change the criteria "<3/18/2011" to a Cell location <P1 which is a cell location with a date reference
set as Today(), the formula returns 0.


any ideas?

thanks

 

[njimack]

=SUMIF('215Open'!A:A,"<"&TODAY(),'215Open'!B:B)

 

[smithrd6]

thanks...works great