Hello first time posting here!
Im currently tasked with creating an attendance sheet that will track an employees accumulated points. I need this sheet to go on for as long as they work for the company so for the life of the career here. This also means this will be for a single employee. What I have currently done is Cell A13 has a date of an occurrence ( 10/5/19 ), Cell C13 has a reason code for the occurrence ( T ). Cell E13 has the points from said occurrence auto filled with this code. =IF(C13= "T",0.5,IF(C13= "A",1,IF(C13= "N",2,IF(C13= "S",0,IF(C13= "E",1,IF(C13= "B",0.5,0))))))

That way I can just add T in for Tardy and it adds .5 in E13. What im trying to do now is have F13 take the entered date in A13 and after 365 days a rolling year has passed take the points accumulated in E13 and make it read as 0 or erase the points all together. Other words show the points for the occurrence active until the 365 days the rolling year has passed. That way when I have H13 count all the points per rolling year I know in a flash how many points total they currently have every time I look at the spread sheet.

Any help on this would be GLADLY accepted as I have been pulling my hair out trying to make this work.