Results 1 to 5 of 5

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
    12
    Thanks
    3
    Thanked 0 Times in 0 Posts
    Hi

    Click image for larger version. 

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

    Click image for larger version. 

Name:	Capture.JPG 
Views:	29 
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:	19 
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
    12
    Thanks
    3
    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!

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
  •