I'm not sure if this is possible on excel but if I wanted to count how many Fridays an employee worked to assign points and then have them automatically drop off after the anniversary date of that point, what would that formula look like?
Example:
Sarah worked 2 Fridays in October 2022, 1 Friday in November, and so on for a full year. I want to total all of those Fridays and then when it's been a year since October 2022, I want those October dates to start dropping off and her points to go down accordingly.
Let me know if that's possible or if I need to elaborate further.
Thank you in advance!!!
Example:
Sarah worked 2 Fridays in October 2022, 1 Friday in November, and so on for a full year. I want to total all of those Fridays and then when it's been a year since October 2022, I want those October dates to start dropping off and her points to go down accordingly.
Let me know if that's possible or if I need to elaborate further.
Thank you in advance!!!