Page 2 of 2 FirstFirst 12
Results 11 to 13 of 13

Thread: Formula to calculate leave due in Excel

  1. #11
    Junior Member rh1's Avatar
    Join Date
    Dec 2017
    Location
    Cape Town
    Posts
    16
    Thanks
    0
    Thanked 1 Time in 1 Post
    @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.

  2. #12
    New Member
    Join Date
    Nov 2021
    Location
    Pretoria, South Africa
    Posts
    3
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Thanks

    Quote Originally Posted by rh1 View Post
    @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?

  3. #13
    Junior Member rh1's Avatar
    Join Date
    Dec 2017
    Location
    Cape Town
    Posts
    16
    Thanks
    0
    Thanked 1 Time in 1 Post
    Quote Originally Posted by Pochahontas View Post
    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

Page 2 of 2 FirstFirst 12

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
  •