Good day everybody,

I need a formula on how to calculate leave days due in Excel.

In the first year of service the employee gets 1 day per month, in the second year of service he gets 2 days per month, and in the third year of service he gets 2.5 days per month.

Please can somebody assist me with this?

Kind regards and thank you in advance!