The following formula works fine, but I want the year for the date within the
quotes to come from a cell reference. Does anyone know how I need to alter
the formula to make this happen? I've tried to replace the 09 with a cell
reference but have had no luck.

=SUMIFS('Check Register'!H2:H1000,'Check
Register'!B2:B1000,"3/31/09",'Check Register'!B2:B1000,"<4/15/09",'Check
Register'!D2:D1000,A43)