Count until

We have a data table that we are continually adding to, we would like to track the updates to this.

I was wondering if there is a way to countA in the table until a nominal date, at which point that number does not change.

We want to know how much we add each month without manually checking. Can excel be set to countA on the 1st of each month so we keep a record of the additions?

Thanks!