Share via

How to add employees leave tracker in excel sheet

Anonymous
2023-11-16T04:24:28+00:00

we are using an excel sheet for employee leaves in my organization. Could you please help me out with how to add all the details with formulas?

Microsoft 365 and Office | Excel | For business | Windows

Locked Question. This question was migrated from the Microsoft Support Community. You can vote on whether it's helpful, but you can't add comments or replies or follow the question.

0 comments

7 answers

Sort by: Most helpful
Most helpful Newest Oldest
  1. Anonymous
    2023-11-16T06:58:07+00:00

    Could you share us a test workbook with some dummy data in it? Then we may put formula on it and send back to you.

    Image

    You may upload attachment in private message.

    0 comments
  2. Anonymous
    2023-11-16T06:26:52+00:00

    we just know how to use formulas for the data. it's sample data you can use for your convenience but you just cover all the parameters that I mentioned in the second picture.

    0 comments
  3. Anonymous
    2023-11-16T05:24:55+00:00

    Could you share us an expected result? Do we use the first picture as raw data? Which one is CL or EL?

    0 comments
  4. Anonymous
    2023-11-16T05:14:30+00:00

    Every year we provide 12 CL & 12 EL, if employees use any leave it should be shown in an excel sheet.

    Leave Type Leave Code Month List
    Casual leave CL January-2023
    Privilege Leave/Earned Leave EL February-2023
    Maternity Leave ML March-2023
    Miscarriage Leave MCL April-2023
    Paternity Leave PL May-2023
    Bereavement Leave BL June-2023
    Long Leave without Pay LWP July-2023
    Work From Home WFH August-2023
    September-2023
    October-2023
    November-2023
    December-2023

    These parameters should be be used.

    0 comments
  5. Anonymous
    2023-11-16T05:01:03+00:00

    Could you share some dummy data and expected result? Then we may give formula suggestions on it.

    0 comments