I'm struggling with getting a formula to work.
I have dates in column H. I simply want to count how many times a date occurs with 2016 (or a referenced cell) in the year.
This is as close as I've gotten, but isn't what I'm wanting as the dates will eventually go past 2016 and then the count will be including 2017 dates.
=COUNTIF(H2:H15,">"&DATE(2016,1,1))
Thanks in advance!
I have dates in column H. I simply want to count how many times a date occurs with 2016 (or a referenced cell) in the year.
This is as close as I've gotten, but isn't what I'm wanting as the dates will eventually go past 2016 and then the count will be including 2017 dates.
=COUNTIF(H2:H15,">"&DATE(2016,1,1))
Thanks in advance!