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!

=COUNTIFS(Categories[LOB/Industry], $A2, Categories[Comp. Map], B$1, Categories[PO Start Date (dd/mo/yy)], ">1/1/"& YEAR())