Morning/Afternoon All,
We have a job sheet with employee names in one column and dates they performed a specific task in another column. What I am struggling with is how to identify how may times an individual has completed the task in the last 365 days.
I was trying and IF with a COUNTIF but no glory.
Guidance greatly appreciated
Regards
Paul
Almost have it, just need to exclude anything after 365 Days
=COUNTIFS(Personnel Names Column,Individuals Name Cell, Dates Column, "<="&TODAY())
what it instead of TODAY() you use the serial data for the last day of the current year,?
I believe that would be:
=COUNTIFS(Personnel Names Column,Individuals Name Cell, Dates Column, ">="&EDATE(TODAY(),-12))
You'll find a working example in the attached sheet.
Riny,
Works perfectly.
Thanks
