+ Reply to Thread
Results 1 to 4 of 4

Attendance Template adjustments

  1. #1
    Registered User
    Join Date
    01-01-2019
    Location
    Denver, Colorado
    MS-Off Ver
    2010
    Posts
    3

    Attendance Template adjustments

    Hi!

    I am trying to adjust the excel template for Employee Attendance and have very little excel knowledge.

    I need to be able to enter dates other than the current year (2019) so that I can use this for our rolling year record. Right now the date automatically corrects to 2019 on the Employee Leave Tracker sheet and so I cannot see the past years (2018) notations.

    It might also help if a formula exists that will delete entries that are more than 360 days old (based on the current date).

    I know that allowing for both years might create an error when dates overlap so if the automatic deletion isn't an option I am happy to manually go through when I input data and delete entries older than 360 days. Just hoping there is some way...

    Also I would like my "Reprimand" that is listed on the "Occurrence Types" Sheet to be able to hold a whole number but not have that number included in the totals listed in "Occurrences" and "Days w/o Occurrence".

    And finally everyone works holidays so I do not want the sheet for "Holidays" at all but am unsure how to remove it from the rest of the sheets code without creating errors.

    Thank you for any help you can give!
    Attached Files Attached Files

  2. #2
    Valued Forum Contributor
    Join Date
    11-02-2016
    Location
    NY
    MS-Off Ver
    2010
    Posts
    459

    Re: Attendance Template adjustments

    There are 'help'/ info in cell A1 of each sheet. Also, if you hover the mouse over some of the cells, there is additional info. Is the previous owner available to inquire how this works? If not, Just type in the current year (if you're working on 2018 then change it on CALENDAR VIEW cell C3. The only thing i would change is on the 2nd tab EMPLOYEE LEAVE TRACKER ~ I would reformat the date to include the Year...this way you will not have difficulty in seeing the year portion of the date ( I believe that this is tab just keeps adding data down for multiple years).
    Reprimand - you could probably change Format on the field where it is entered.
    Holidays - i would just ignore it. It may be used in future. Without the details of the wks or its author, I would just ignore it.

  3. #3
    Registered User
    Join Date
    01-01-2019
    Location
    Denver, Colorado
    MS-Off Ver
    2010
    Posts
    3

    Re: Attendance Template adjustments

    I changed the date columns as you suggested and that has it all working properly, the other part of that problem was a lack of data for 2018 so silly of me!

    Thanks!
    Last edited by kitkattasu; 01-02-2019 at 03:18 PM.

  4. #4
    Registered User
    Join Date
    01-01-2019
    Location
    Denver, Colorado
    MS-Off Ver
    2010
    Posts
    3

    Re: Attendance Template adjustments

    Here is the updated worksheet!

    Still looking for a formula to delete anything older than 365 days (from current date) off of the "Occurrence Tracker" sheet.

    Attached Files Attached Files
    Last edited by kitkattasu; 01-02-2019 at 03:19 PM.

+ 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. Employee attendance tracker template
    By buhhan in forum Excel Charting & Pivots
    Replies: 3
    Last Post: 07-13-2017, 03:58 AM
  2. [SOLVED] Employee Attendance Template
    By mcanny in forum Excel Formulas & Functions
    Replies: 6
    Last Post: 01-18-2016, 01:07 PM
  3. Excel 2007 : Excel 7 - Attendance Template
    By Mark1970 in forum Excel General
    Replies: 2
    Last Post: 01-06-2012, 06:32 AM
  4. Student Attendance Record Template
    By Nita in forum Excel General
    Replies: 6
    Last Post: 06-09-2006, 09:15 AM
  5. [SOLVED] How do I populate 2006 calendar into the attendance template.
    By Lmorford in forum Excel Formulas & Functions
    Replies: 0
    Last Post: 03-08-2006, 03:55 PM
  6. [SOLVED] FIX ATTENDANCE CALENDAR TEMPLATE - INCORRECT DATE
    By Incorrect Template Name in forum Excel General
    Replies: 0
    Last Post: 07-22-2005, 02:05 AM

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