Forum Discussion
MBelshaw
Oct 30, 2019Copper Contributor
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...
tauqeeracma
Oct 30, 2019Steel Contributor
Hi MBelshaw
You can use Countifs() function to achieve your requirement:
=COUNTIFS(A:A,">=1/1/19",A:A,"<=31/1/19")
A sample file is also attached for your reference. Please let me know if it works for you.
Thanks
Tauqeer