Formula to subtract attendence points after 30 days, but only to one instance at a time.

[seanjon]

Good Day!

The company allows for 5 attendence points to be removed after 30 days of no instances. I have a tracker that does that, but unfortunately, I didn't account for it to apply it to all the cells that carry points. For example, 5 points were assigned 45 days ago, another 5 40 days ago and 3 points 35 days ago. After 30 days of no instances, the 5 points from 45 days ago should be adjusted to zero, which the formula did, however, it also removed the points from 40 and 35 days ago. How do I make it so it only does it once every 30 days?
A = Employee, B= Start date, C = Stop Date, D = Type of absence, E= leave used, F=Points assigned, G=Notes, H=adjusted points

F should not change at all. Once it is input, this will stay. F is where I need to put the formula in do that it removes 5 points After 30 days only if there is no other instance from today - 30 days. Hoever, it needs to do it only once per 30 days. This is the formula I have at this time: =IF(AND(A3<>"", TODAY() - MAXIFS(C:C, A:A, A3) >= 30), MAX(0, F3 - 5), F3)

Thanks for your time and support.

 

[arthurbr]

Your profile does not say which XL version you are using??

 

[seanjon]

Your profile does not say which XL version you are using??

Sorry - 2019. Thanks you

 

[Joe4]

I suggest that you update your Account details (or click your user name at the top right of the forum) so helpers always know what Excel version(s) & platform(s) you are using in the future, as the best solution often varies by version. (Don’t forget to scroll down & ‘Save’)

 

[seanjon]

I suggest that you update your Account details (or click your user name at the top right of the forum) so helpers always know what Excel version(s) & platform(s) you are using in the future, as the best solution often varies by version. (Don’t forget to scroll down & ‘Save’)

Done - thank you