Concatenating Criteria in DSUM

[Michael Conroy]

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.

 

[Ashish Mathur]

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

 

[Jacob Skaria]

Another way

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

If this post helps click Yes