# Thread: Formula to calculate leave due in Excel

1. ## Formula to calculate leave due in Excel

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!

2. Hi

3. Thank you so much!!!!!! It is perfect!!!

5. Hi Everybody!

We are nearly there. I am still struggling with this formula.

For some of the employees it is giving them one day extra?

Please, is there anybody that can assist with this?

https://www.dropbox.com/s/cop9ujoyok...20HB.xlsx?dl=0

6. Just be careful, you have to give them at least 1,25 days per month (for a 5 day work week)

7. Originally Posted by dellatjie
Just be careful, you have to give them at least 1,25 days per month (for a 5 day work week)
That would assume the South African Basic Conditions of Employment Act is applicable. In this instance I believe the query comes out of Mozambique.

8. Hi All,

9. Hi Could you please share it again?

10. BCEA gives a minimum of 15 days per annum leave. It can be increased but never decreased.

No specific formula - 1.25 x 12 = 15 days per annum.

Normally I create columns as follows:
Column A = Description - i.e. January Leave Accrual, February Leave Accrual etc
Column B = Accrued - 1.25 (copy this write down)
Column C = Taken -
Column D = Balance

So it would look like this:

The formula in Cell D3: =D2+B3+C3

Copy this down for the first year in the balance column

Year 2 D16 = =D14+B16+C16

Page 1 of 2 12 Last