=SUMPRODUCT(--(A2:A100DATEVALUE("9/22/04")),--(A2:A100<DATEVALUE("9/21/05")),B2:B100)

check out
http://www.xldynamic.com/source/xld.SUMPRODUCT.html
for details on the sumproduct function

"Pam" wrote:

I have an excel spreadsheet with employees time off. I need a formula that
will add column b if column a is betwee two dates. For example: if column a
is between 9/22/04 and 9/21/05 then add column b. I have tried all different
formluas but can't get this to work.