count cells in a column date range excluding the future

[AwesomeSteph]

I have a chart that shows progress, my customer doesn't want the line on the chart to exceed past "today". Also doesn't want it dropping off. He wants it to just stop at today but continue to show projected. Is there a way to change my formula to count cells only if they are in the past? =countif(range, today()-1) but with a large formula in the range? I've tried to just throw it in but it isn't working. The formula that I'm using currently that is producing a flat line across the chart is:

 =SUM(SUMPRODUCT((sheet1!E3:E445>43315)*(sheet1!E3:E445<=43322)),SUMPRODUCT((sheet2!E3:E502>43315)*(sheet2!E3:E502<=43322)),D2)

 

[Special-K99]

"doesn't want...to exceed past today"
So today is included but not tomorrow since today does not exceed today.

Isn't this just a case of adding

(Sheet1!E3:E445<=TODAY())
and
(Sheet1!E3:E502<=TODAY())

to each SUMPRODUCT ?

 

[Special-K99]

"doesn't want...to exceed past today"
So today is included but not tomorrow since today does not exceed today.

Isn't this just a case of adding

(Sheet1!E3:E445<=TODAY())
and
(Sheet1!E3:E502<=TODAY())

to each SUMPRODUCT ?