Date Issue

[Carlee]

Hi all,

I use this formula to pull specific rows out of a master sheet and sum their
totals. In this instance, all rows for the month of January:

=SUMPRODUCT(--('Daily Reading Master
Log'!B3:B400>=DATEVALUE("01/01")),--('Daily Reading Master
Log'!B3:B400<=DATEVALUE("30/01")),'Daily Reading Master Log'!BU3:BU400)


Question: How can i make the date more generic so i will not have to update
the formula each year? I would like the formula to look for the month and
day only...and not worry about the year because only one year of data will be
held in the workbook.

Ideas?

 

[Norman Jones]

Hi Calee,

DATEVALUE("01/01") and DATEVALUE("30/01") will
always return dates in the current year