Results 1 to 7 of 7

Thread: Formula to calculate leave due in Excel

  1. #1
    New Member
    Join Date
    Nov 2018
    Location
    Vilanculos
    Posts
    3
    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:	55 
Size:	29.2 KB 
ID:	7308

    Click image for larger version. 

Name:	Capture.JPG 
Views:	185 
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:	157 
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
    3
    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
    3
    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
    284
    Thanks
    52
    Thanked 39 Times in 35 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
    21,619
    Thanks
    3,127
    Thanked 2,522 Times in 2,123 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.
    The trouble with opportunity is it normally comes dressed up as work.

    Alcocks Electrical Services | Alcocks Pest Control & Entomological Services

Similar Threads

  1. [Question] Calculate Fair Value and Reserve Value
    By JPWilliams007 in forum Accounting Forum
    Replies: 0
    Last Post: 09-May-18, 07:45 PM
  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
  •