The formula I'm using is "=if(datevalue("08/10/2005")
<=$c3<=datevalue("09/09/2005"),$E3,0)". I have a transaction date of
09/05/2005 in cell c3 and a transaction amount of $3,500 in cell e3. My
formula is not returning a value of $3,500. The logical test from the
formula is returning false. There are no other add-in tools to include in
the Excel start up.