Named Ranges in Functions

[Guest]

hi all,

I am using the following function to get a year-to-date value:
=SUMPRODUCT(--('Daily Reading Master
Log'!B$3:B$375>=DATEVALUE("01/01")),--('Daily Reading Master
Log'!B$3:B$375<=DATEVALUE("10/31")),'Daily Reading Master Log'!AD$3:AD$375)

This works great when i specify a given date. I want to replace the second
date in this array with a Named Range called rptDate. When i try to do this,
i get an error. Can I do this, and if so, what do i need to do?

 

[JE McGimpsey]

If the value in rptDate is a date (rather than a Text string):

=SUMPRODUCT(--('Daily Reading Master
Log'!B$3:B$375>=DATEVALUE("01/01")),--('Daily Reading Master
Log'!B$3:B$375<=rptDate),'Daily Reading Master Log'!AD$3:AD$375)

 

[Guest]

Marvellous!!! Thank you so much!
--
Carlee

If the value in rptDate is a date (rather than a Text string):

=SUMPRODUCT(--('Daily Reading Master
Log'!B$3:B$375>=DATEVALUE("01/01")),--('Daily Reading Master
Log'!B$3:B$375<=rptDate),'Daily Reading Master Log'!AD$3:AD$375)