Calculate total number of working days in a given quarter
Summary:
Calculate total number of working days in a given quarter.
Content (please ensure you mask any confidential information):
We have an accrual plan that accrues balance start of the quarter and each quarter has different accrual hours.
The requirement is to prorate the accrual based on hire-date and the quarter in which he was hired. Logic should be:
Accrual of the quarter * (Calculated working days from the date of hire to end of quarter/Total number of working days in the quarter)
I am looking for pointers to calculate Total number of working days in the quarter. Do we have any in-built function or any other workaround that can help?