You're almost there! Please answer a few more questions for access to the Applications content. Complete registration
Interested in joining? Complete your registration by providing Areas of Interest here. Register

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?

Howdy, Stranger!

Log In

To view full details, sign in.

Register

Don't have an account? Click here to get started!