Date Issue

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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?
 
Hi Calee,

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