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

Hi,

You may use this

=AND(MONTH(C8)=1,YEAR(C8)=2009)

Just ensure that the heading of this criteria is not equal to the heading in
the first row of your data list

--
Regards,

Ashish Mathur
Microsoft Excel MVP
www.ashishmathur.com

"Michael Conroy" wrote in message
...
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

Another way

=TEXT(A1,"MMYYYY")="012009"

If this post helps click Yes
---------------
Jacob Skaria


"Michael Conroy" wrote:

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