holiday entitlement and prorata

Public Schedule Face-to-Face & Virtual Instructor-Led Training - View dates & book

• Home
• Courses
• Promotions
• Schedule
• Formats
• Our Clients

Forum home » Delegate support and help forum » » Holiday Entitlement and Pro-Rata based on Length of Service

# Holiday Entitlement and Pro-Rata based on Length of Service

Resolved · High Priority · Version 2016

Precious has attended:
Excel Intermediate course

### Holiday Entitlement and Pro-Rata based on Length of Service

At my company we have launched our benefits scheme and I need to calculate what entitlement will be for leavers if the leave part way through the year but are still entitled to the length of service extra holiday entitlement.

### RE: Holiday Entitlement and Pro-Rata based on Length of Service

Hi Precious

You would need to use the IF function to allow Excel to make the decision to check the entitlement and then include it.

So it could look something like this:-

=IF(Length of Service >= Long Service, Additional Holidays, Nothing)

This would display the additional holiday entitlement or 0

You would then include in the adjacent columns the calculation to workout the value of the additional holiday e.g. Value of Additional Holidays = £ Daily Salary * Additional Holidays

As discussed in the training course, prepare all your calculations prior to commencing creating your spreadsheet as this will give you clear guidance as to what needs to be included.

Feel free to get back in touch when you're closer to creating the calculations.

Regards

Dennis

Thu 5 Nov 2020: Automatically marked as resolved.

Training courses

Training information:

 Welcome. Please choose your application (eg. Excel) and then post your question. Our Microsoft Qualified trainers will then respond within 24 hours (working days). Frequently Asked Questions What does 'Resolved' mean? Any suggestions, questions or comments? Please post in the Improve the forum thread.

### Separate the year from a date

To separate the year from a date use the =year() function, eg a date is in cell A1 and in A2 you wish to display the year enter the function =year(A1)

View all Excel hints and tips