[Question] Formula to calculate leave due in Excel

[Helizelb]

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!

[JKS]

Hi





link to file: https://we.tl/t-QOz4Pmq37F

[Helizelb]

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

[JKS]

Made a small change to one of the functions. please download again.

[Helizelb]

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/cop9ujoyok9150d/Leave%20HB.xlsx?dl=0

Thank you in advance!

[dellatjie]

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

[Dave A]

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.

[Pochahontas]

Hi All,

Could someone please share the spreadsheet again? I also need one

[Pochahontas]

Hi Could you please share it again?

[rh1]

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

[rh1]

@Pocohantas In a small organisation, I would create a worksheet per employee as indicated in my post above. With the first work sheet being a summary as the per original worksheet indicated above. This enable you to look at an individual leave or you can look at the entire company.

If you are a bigger organisation, buy a software solution.

[Pochahontas]

Thanks

@Pocohantas In a small organisation, I would create a worksheet per employee as indicated in my post above. With the first work sheet being a summary as the per original worksheet indicated above. This enable you to look at an individual leave or you can look at the entire company.

If you are a bigger organisation, buy a software solution.

Thank you! Is the leave per month for year 2 2days per month?

[rh1]

Thank you! Is the leave per month for year 2 2days per month?

Yes. The original poster stated 1 day and then 2 day in the next year. But if it remains the same, just make it 1.25

[Cheri]

Hi

[ATTACH=CONFIG]7308[/ATTACH]

[ATTACH=CONFIG]7312[/ATTACH]

link to file: https://we.tl/t-QOz4Pmq37F

Hi! Can you please share this file with me?