Your countifs formula is coming back with 0 you have countifsa2a6 and h2a2a6 and h5a2a60 a column is your dates h2 is current date h5 is a year from current date evaluate formula is clear?

It seems there may be an issue with how the ranges and criteria are set up in your COUNTIFS formula. Double-check that the ranges A2:A6 and H2:A2:A6 are correctly defined and that you're using the correct syntax for referencing dates. Additionally, ensure that the date in H2 is in the correct format and falls within the range of dates in A2:A6. If the criteria for H5 (a year from the current date) is not correctly set, it could also lead to a result of 0.