DSUM

[Chuck]

I'm using Dsum Fx to result data from a table. I have two
cells creating an "and" query. I'm looking for data in a
range of dates. Each of the two cells contains dates
along with a < or >, = sign to get the range, ie >=1-1-04
and <=1-31-04. This returns the values between the two
dates, however I want two other cells to calculate a
subtraction of one year. This will give a new Dsum Fx the
previous year data.

The >= Symbols change the format of the date cell. Any
suggestions?

 

[Debra Dalgleish]

You could enter the start and end dates in empty cells on the worksheet,
then refer to those dates in the criteria range. For example, with the
start date in cell J1, and end date in K1, change your current criteria
range to:

Date Date
=">="&J1 ="<="&K1

and for the previous year data:

Date Date
=">="&DATE(YEAR(J1)-1,MONTH(J1),DAY(J1))
="<="&DATE(YEAR(K1)-1,MONTH(K1),DAY(K1))