All articles with 'Excel for HR' Tag

How much long service bonus to pay? [Homework]

Published on Dec 8, 2017 in Formula Challenges

‘Tis Friday and it is too hot in my home office to stand and type a longish post. So, let’s keep this skirtish (short and pretty).

How would you calculate long service bonus?

Let’s say you are HR manager at BigLargeInc. and you are looking at┬áJulia’s service details. You have her employment start date, current date, her leave without pay details, as shown below.


You need to calculate how many days of continuous service Julia had (ie total service – duration on leave without pay). How would you write the formula?

Continue »