When setting up the criteria range for a DSum function, I have to use two
columns to get a date range. Does anyone know if there is a trick to
concatenating the two dates into one criteria string as demonstrated below?

Date Date
12/31/2008 <2/1/2009 for all of January but using two columns

What I am looking for is:
Date
12/31/2008 and <2/1/2009 didn't work
12/31/2008<2/1/2009 didn't work
and(12/31/2008,<2/1/2009) didn't work

The month and day are hard coded, but the year changes based on the date in
one cell of the criteria worksheet. This way I can change the year quickly.

--
Michael Conroy
Stamford, CT