How to determine the number of absence/payroll days since the employee gone on Leave on Absence?

Summary:

I have a requirement/to build an analysis report which should determine the number of days after someone back from their "leave of absence" or "Leave with Pay" to "Payroll Active" Status,

Content (required):

I should build an analysis report which should pick the learners who is gone for "Leave of absence/Leave with Pay" more than 180 days and they are "Return to Work" later.

Version (include the version you are using, if applicable):

22B

Code Snippet (add any code snippets that support your topic, if applicable):

I wonder, does anyone have any idea of which subject area and the logic to achieve the above requirement to assign the eligible learners to the specific course.