PTO Date Range Reporting
We have a PTO request application in which users submit requests for time off. There is reporting that is used by our payroll folks to enter the PTO dates into our payroll system.
So users don't have to fill out the form for each day they are on vacation we built the app so they entered a start and end date. If they will only be out one day they enter the same date in both fields.
Each Monday our payroll people look for dates in the past work week and enter those into the payroll system.
What I'm struggling with is how to get them that report. It should show any approved PTO for the previous Monday through Friday. Is there a way to parse out the dates between the start and end date somehow?
I'm not sure how to get them that report without having the users enter a row for each day they will be out.
I did create a column to show how many days the dates span, that may have to be enough unless someone out there has a better idea for how to do this.
Best Answer
-
You will probably need to create a table of dates to create a date scaffold, and then do something like what is described here:
Answers
-
You will probably need to create a table of dates to create a date scaffold, and then do something like what is described here:
-
@James Keuning thanks for the tip. I may just do a count of the workdays between my start date and end date so the person entering the PTO can see that there are multiple days to be entered between those dates. I'll have to see if that's an OK solution for the business.
-
If it were me, I would start there. Often times we go so crazy trying to get things perfect, only to find out that the HR person doesn't trust the numbers and does a manual count anyway.
Help Article Resources
Categories
Check out the Formula Handbook template!
