Stop Counting After Today

Hi everyone,

I am trying to find out how to produce a formula that will stop counting after the day is over. For example, i have a spreadsheet that is calculating the total number of pending questions for multiple project types which are found on seperate tabs. The first tab of my spreadsheet is a Summary tab which displays the statistics of each project tab including how many questions we have pending. The number of questions are calculated by picking up how many cells display "Y" in the PQ (pending questions) column of each tab.

Our current process is to type in the number displayed in the summary that shows how many questions we have pending. What that does, is freeze the total number of questions we had pending for that day. I am trying to make this more automated by coming up with a formula that will freeze this number on its own.

If I write out what I am trying to do, it would go something like this:

Count cells with "Y" and stop counting after today

I feel like this could have a simple solution but I am not finding a thread that can help me with this.

Current formula in cell:

=COUNTIF(MDU!$L$6:$L$1000,"=Y")+COUNTIF(SDU!$L$6:$L$1000,"=Y")

Your help is very much appreciated