Dynamic date check inside Countifs

[mtnbiker98]

Hello, All.

I am working with Countifs and would like to add a condition to only count if the date in the row is later than 1/1/<this year>. I would like this year to be dynamic so the sheet doesnt have to be recoded next year.

I have tried several methods including the following and have not gotten anywhere. Any suggestions would be most welcomed. Thank you!

Please Login or Register  to view this content.

[rcm]

use year(today()) instead

[mtnbiker98]

Thank you very much! I spent 30 mins dancing around that one and it was an easy fix.