+ 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 2016
    Posts
    4,824

    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 ( It doesn't hurt )

+ Reply to Thread

Thread Information

Users Browsing this Thread

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

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