I want to replace "1/1/05" and "3/31/05" in the below formula with a
Date Function so that the formula will automatically update for the
current year, ie, 1/1/05, 1/1/06, 1/1/07, etc.


{=SUM(SUMIF($A$22:$A$200,{">=1/1/05","<=3/31/05","<>"},B22:B*200)*{1,1,-1})}


Thanks