Calculating Last 30-60 Days + % Per Day Period

[YRSTRULY]

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 %)

Assume today's date it August 1, 2021.

My calculation for days off. I subtract from date to date. Is it correct

[alansidman]

Administrative Note:

Welcome to the forum.

Unfortunately, this is a duplicate thread, and you are allowed only ONE thread per issue here.

Please see Forum Rule #5 about thread duplication.

I am closing this thread, but you may continue in the original thread