Date Issue
 

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?
--
Carlee

Date Issue
 

Hi Calee,

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


---
Regards,
Norman


"Carlee" wrote in message
...
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<='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?
--
Carlee