Howdy,

I am having a little trouble with countifs and multiple criteria including a date. I have a set of data with the work division, rank, and date of rank. I need a formula to only count the rank if it is within a year of the date I write in a particular cell. I have an example of what I am having trouble with.

I think a sumproduct might work if only two conditions, but I have 3 conditions I'm looking at. The divison the employee works, the rank of the employee, and the date of rank of the employee.

Thanks for any help.

Date Conditions.xlsx