+ Reply to Thread
Results 1 to 2 of 2

90 rolling attendance tracker

  1. #1
    Registered User
    Join Date
    10-03-2012
    Location
    Johnson City, TN
    MS-Off Ver
    Excel 2013
    Posts
    12

    90 rolling attendance tracker

    I have two things I am trying to accomplish with this attendance log for my company. I need to be able to track out employees attendance and calculate their attendance occurences when they miss. I have gotten the worksheet to calculate using the IF forumale however am now constricted by the length of the formula. I am hoping that I can get help with shortening this down or an easier to accomplish what I am trying to do.

    In Column E the sheet looks through columns F through CQ to see if an employee has any of the following AU, LEU, LEU1, TU, NCNS, or LLU. Each of these have different meanings however some of them share the same occurence value. What I want to do if go into the Columns of F through CQ and place any of the characters in and then column E will sum up their 90 day ocurrence value. AU = 1, LEU = .33, LEU1= 1, TU = .33, NCNS = 3, & LLU = .33

    Currently this formula looks something along the lines of this
    Please Login or Register  to view this content.
    I believe this could be shortened out to combine Reasons like AU, LEU1 & LEU, TU, LLU.

    Secondly I need this workbook to be updated to maintain 90 days. With what I currently Have I try to delete the oldest date and insert the newest but the Formula seems to break everytime and cannot figure out how to keep this intact so I can simply add the current date and remove the oldest.

    Rather it would be easier to maintain just the first sheet for the year and 90 days and have Column E look at todays date and sum all the occurence values for todays date plus the prior 90 days.

    Any help would be appreciated.
    Attached Files Attached Files
    Last edited by Fuhgawz; 12-20-2013 at 04:11 PM.

  2. #2
    Forum Expert
    Join Date
    11-26-2013
    Location
    Colac, Victoria, Australia
    MS-Off Ver
    Excel 2016
    Posts
    1,309

    Re: 90 rolling attendance tracker

    Here is a smaller formula:

    Formula: copy to clipboard
    Please Login or Register  to view this content.


    This gives a different result to yours, but I suspect there is an error in yours somewhere.

    To get your rolling 90 days working, just insert a blank column before column F, but still include the new blank column F in your formula - and push it out to CR. This way when you delete the 4th October, you won't be messing up your formula.

    Hope this helps.

    Merry Christmas!

    David


    When you reply please make it clear WHO you are responding to by mentioning their name.
    If we have been of assistance, please let us know. A little thanks goes a long way.
    - Please click on the *Add Reputation button at the bottom of helpful responses.
    Please mark your thread as SOLVED:
    - Click Thread Tools above your first post, select "Mark your thread as Solved".

+ 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. Attendance Tracker
    By bsoper in forum Excel General
    Replies: 6
    Last Post: 10-06-2015, 09:56 PM
  2. [SOLVED] Attendance Tracker
    By rajeshntiwari in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 05-03-2012, 04:07 PM
  3. Attendance Tracker,
    By excelkeechak in forum Excel General
    Replies: 8
    Last Post: 05-11-2010, 08:59 PM
  4. Attendance Tracker
    By shanny in forum Excel Formulas & Functions
    Replies: 6
    Last Post: 03-06-2008, 08:44 AM
  5. attendance tracker
    By jennyn in forum Excel General
    Replies: 2
    Last Post: 01-11-2006, 03:10 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