Nov 18 2021 12:18 PM
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...