‘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 has (ie total service – duration on leave without pay). How would you write the formula?
Assume cell references as shown in the picture above.
Please post your answers in comments.
Bonus question? Think Julia’s troubles are nothing? Then come up with formulas to tell how many years and months of long service Julia had. Assume each year has 365.25 days and 12 months in it.
Answers for the example above:
For the above data, you should get below answers
- Continuous service days: 4,870
- Continuous service in years and months: 13 years and 4 months
Go ahead and post your formulas in comments. Julia is waiting for her bonus.
