Calculating Last 30-60 Days + % Per Day Period

New Contributor

Please assist. I would like to calculate ...
Number of team members who have not used a PTO in the last 30, 60, 90 days (include % per 30-day period) - Number of team members who used more than 3 PTO in the last 90 days (include %) - How many PTOs were cancelled? How many were declined? How many were not actioned on?(include %)

[B]Assume today's date it August 1, 2021.[/B]

My calculation for days off. I subtract from date to date. Is it correct
See: https://docs.google.com/spreadsheets/d/1eXFU6vgEoMAPYFZl8UClknSEt6kdS5sv/edit?usp=sharing&ouid=10412...

0 Replies