Page 1 of 2 12 LastLast
Results 1 to 10 of 14

Thread: Formula to calculate leave due in Excel

  1. #1
    New Member
    Join Date
    Nov 2018
    Location
    Vilanculos
    Posts
    5
    Thanks
    0
    Thanked 0 Times in 0 Posts

    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. #2
    Junior Member
    Join Date
    Jun 2011
    Location
    Cape Town
    Posts
    13
    Thanks
    4
    Thanked 0 Times in 0 Posts
    Hi

    Click image for larger version. 

Name:	leave days.jpg 
Views:	1101 
Size:	29.2 KB 
ID:	7308

    Click image for larger version. 

Name:	Capture.JPG 
Views:	1731 
Size:	54.3 KB 
ID:	7312

    link to file: https://we.tl/t-QOz4Pmq37F
    Attached Thumbnails Attached Thumbnails Click image for larger version. 

Name:	leave days 1.JPG 
Views:	1126 
Size:	60.8 KB 
ID:	7309  
    Last edited by JKS; 23-Nov-18 at 07:49 AM.

  3. #3
    New Member
    Join Date
    Nov 2018
    Location
    Vilanculos
    Posts
    5
    Thanks
    0
    Thanked 0 Times in 0 Posts
    Thank you so much!!!!!! It is perfect!!!

  4. #4
    Junior Member
    Join Date
    Jun 2011
    Location
    Cape Town
    Posts
    13
    Thanks
    4
    Thanked 0 Times in 0 Posts
    Made a small change to one of the functions. please download again.

  5. #5
    New Member
    Join Date
    Nov 2018
    Location
    Vilanculos
    Posts
    5
    Thanks
    0
    Thanked 0 Times in 0 Posts
    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!

  6. #6
    Silver Member
    Join Date
    Sep 2012
    Location
    Louis Trichardt
    Posts
    334
    Thanks
    58
    Thanked 43 Times in 39 Posts
    Just be careful, you have to give them at least 1,25 days per month (for a 5 day work week)

  7. #7
    Site Caretaker Dave A's Avatar
    Join Date
    May 2006
    Location
    Durban, South Africa
    Posts
    22,646
    Thanks
    3,304
    Thanked 2,676 Times in 2,257 Posts
    Blog Entries
    12
    Quote Originally Posted by dellatjie View Post
    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. #8
    New Member
    Join Date
    Nov 2021
    Location
    Pretoria, South Africa
    Posts
    3
    Thanks
    0
    Thanked 0 Times in 0 Posts
    Hi All,

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

  9. #9
    New Member
    Join Date
    Nov 2021
    Location
    Pretoria, South Africa
    Posts
    3
    Thanks
    0
    Thanked 0 Times in 0 Posts
    Hi Could you please share it again?

  10. #10
    Junior Member rh1's Avatar
    Join Date
    Dec 2017
    Location
    Cape Town
    Posts
    16
    Thanks
    0
    Thanked 1 Time in 1 Post
    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:
    Click image for larger version. 

Name:	SNipping.jpg 
Views:	327 
Size:	51.7 KB 
ID:	8402

    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 LastLast

Similar Threads

  1. [Question] Calculate Fair Value and Reserve Value
    By JPWilliams007 in forum Accounting Forum
    Replies: 1
    Last Post: 28-Nov-19, 10:10 AM
  2. Vat formula not calculating correctly in Excel
    By NVRensburg in forum Accounting Forum
    Replies: 4
    Last Post: 07-Feb-18, 01:25 PM
  3. Maternity leave, leave accrual and minimum number of days annual leave
    By Jakoos in forum Labour Relations and Legislation Forum
    Replies: 2
    Last Post: 05-Mar-17, 08:49 AM
  4. [Question] Excel Spreadsheet to calculate weekly wages
    By Dientjie in forum Technology Forum
    Replies: 6
    Last Post: 26-Jun-15, 07:21 AM
  5. Formula to calculate staff costs against profit
    By Jacky in forum Accounting Forum
    Replies: 4
    Last Post: 23-Oct-14, 09:17 AM

Tags for this Thread

Did you like this article? Share it with your favourite social network.

Did you like this article? Share it with your favourite social network.

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •