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.

[Pochahontas]

Hi Could you please share it again?

[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]

@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





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

Hi! Can you please share this file with me?

[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/cop9ujoyok...20HB.xlsx?dl=0

Thank you in advance!