Results 1 to 11 of 11

Anniversary Start date to reset Employees Sick leave and Vacation Time

Threaded View

  1. #1
    Registered User
    Join Date
    04-13-2021
    Location
    New Hampshire
    MS-Off Ver
    MS365
    Posts
    6

    Anniversary Start date to reset Employees Sick leave and Vacation Time

    Hello All,

    Disclaimer, I am a noob at excel so I hope I can describe things clearly.
    I am working off of this Employee Attendance template that I searched for in the excel program. I was able to enter in functions to pull up the employees sick days and vacation time(K3 and R3). I am running into an issue where the amounts reset at the beginning of each calendar year, when I want it to reset at the anniversary date for the employee. And I am just stuck. What my ideal situation would be is that K3 and R3 are able to calculate remaining days based off of the anniversary date. I would also love to be able to roll over any unused vacation time into the next year. The sick days do not roll over and would reset to 3 on the anniversary date. I really like everything else about this template, and the person that would be in charge of inputting information has far less experience with excel than I do, so I am trying to streamline everything for that individual. On the "List of Employees" sheet I have their vacation days as their totals(including rollovers), but I think eventually that would be just their base days, and the rollover would happen through the functions instead of being done manually. That way as employees gain more total vacation days(from more years at the company) that can be changed in that sheet.

    Thank you all for any help in advance, it's greatly appreciated!
    Attached Files Attached Files

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. Replies: 5
    Last Post: 03-03-2015, 01:38 PM
  3. Replies: 2
    Last Post: 01-31-2013, 02:01 PM
  4. Replies: 0
    Last Post: 01-31-2013, 01:42 PM
  5. Vacation/Sick Leave accruals
    By Carisa in forum Excel Formulas & Functions
    Replies: 5
    Last Post: 09-27-2012, 09:47 PM
  6. Reset button after anniversary date (vacation schedule)
    By jerger in forum Excel Programming / VBA / Macros
    Replies: 9
    Last Post: 11-14-2009, 07:31 PM
  7. vb or function: reset vacation on anniversary date
    By jerger in forum Excel Formulas & Functions
    Replies: 7
    Last Post: 11-09-2009, 02:55 PM

Tags for this Thread

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