+ Reply to Thread
Results 1 to 2 of 2

Need help to create a personal leave(vacation) tracking for work.

  1. #1
    Registered User
    Join Date
    11-09-2013
    Location
    Malaysia
    MS-Off Ver
    Excel 2010, 365
    Posts
    3

    Need help to create a personal leave(vacation) tracking for work.

    I need to create a personal leave tracking for my work.
    The remaining leave(days) will carry forward to this year but will expired on end of March.
    Before the expired month (end of March), my leave taken will deduct from the forwarded days from last year first, then only deduct from this year entitled days if it is not enough.
    After March, if there are still remaining days (last year) it will be burn (0)

    I've attached the file I created halfway, but got no idea on the formula.
    Can someone have a look & help?

    Thank you.
    Attached Files Attached Files

  2. #2
    Forum Expert Keebellah's Avatar
    Join Date
    01-12-2014
    Location
    The Netherlands
    MS-Off Ver
    Office 2021 (Windows)
    Posts
    7,900

    Re: Need help to create a personal leave(vacation) tracking for work.

    got the file, will see if I can help
    ---
    Hans
    "IT" Always crosses your path!
    May the (vba) code be with you... if it isn't; start debugging!
    If you like my answer, Click the * below to say thank-you

+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Similar Threads

  1. Sick/Vacation leave accrual
    By jzamoralopez in forum Excel General
    Replies: 1
    Last Post: 12-05-2018, 11:06 PM
  2. [SOLVED] Populating vacation leave.
    By aries_01463 in forum Excel General
    Replies: 2
    Last Post: 09-28-2015, 01:53 AM
  3. Replies: 5
    Last Post: 03-03-2015, 01:38 PM
  4. Vacation/Sick Leave accruals
    By Carisa in forum Excel Formulas & Functions
    Replies: 5
    Last Post: 09-27-2012, 09:47 PM
  5. Vacation Tracking
    By sherriehere in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 10-24-2011, 02:18 AM
  6. Vacation and Sick Tracking
    By Olympus in forum Excel General
    Replies: 7
    Last Post: 01-12-2011, 04:16 PM
  7. Vacation Tracking Schedule
    By gordonh8r in forum Excel General
    Replies: 1
    Last Post: 01-10-2006, 09:55 PM

Bookmarks

Posting Permissions

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

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1