Absence Forecasting - Accounting for Future Dated Requested

Hello,

Is there any way to account for future dated absence requests when Forecasting?

Here is an example of the problem we're running into:

On 4/7/22 Employee added a vacation day for 10/10 and it was approved and eligible. 

On 6/27/22 Employee added another vacation request for 7/27-7-29. This was approved and eligible, but when payroll ran, it made the 10/10 request ineligible. 

We're hoping to catch this during Forecasting.

I was thinking of creating an Accumulator that gets Takes for the entire year and look at that but I was hoping someone else has faced this issue before and could offer some insight.