+ Reply to Thread
Results 1 to 2 of 2

Keeping track of attendance point system

  1. #1
    Registered User
    Join Date
    11-12-2009
    Location
    Ardmore, OK
    MS-Off Ver
    Excel 2003
    Posts
    1

    Keeping track of attendance point system

    I need to track the number of points accumulated during the past 6 months. We use a point system to track attendance over the last 6 months. Tardys count as 0.5, then callouts count either as 1 or 1.5 points. NCNS counts as 5.

    Column A is the Months and the top row is the days of the months. Here is as example:

    Janurary 1 2 3 4 5 6 7 8 9 10 11 12 13 14 15
    February
    March 0.5
    April
    May 1
    June
    July 1.5
    August
    September
    October 1
    November
    December
    January

    I currently have to manually delete points that are older than 6 months. Is there a way I can assign each cell a date? This way I can have a formula that only counts dates present and back to 6 months.

    Thank you for any ideas and assistance.

  2. #2
    Forum Expert dredwolf's Avatar
    Join Date
    10-27-2012
    Location
    Clearwater,Canada
    MS-Off Ver
    Excel 2007
    Posts
    2,649

    Re: Keeping track of attendance point system

    I would need to see a sample of the data here, otherwise, how can I give you an answer?
    I see what you would like to see appear for Jan (I think), but none of the data that you use to get there!

    Edit-
    Actually, see some data that might be under the 1 column...but no Idea of why it's supposed to be there...
    Last edited by dredwolf; 10-30-2013 at 11:11 PM.
    A picture may be worth a thousand words, BUT, a sample Workbook is worth a thousand screenshots!
    -Add a File - click advanced (next to quick post), scroll to manage attachments, click, select add files, click select files, select file, click upload, when file shows up at bottom left, click done (bottom right), click submit
    -To mark thread Solved- go top of thread,click Thread Tools,click Mark as Solved
    If you received helpful response, please remember to hit the * of that post

+ 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 Point System Spreadsheet with Rolling 1-year Points Reversal
    By mfoley9723 in forum Excel Formulas & Functions
    Replies: 6
    Last Post: 11-04-2018, 04:46 PM
  2. Replies: 10
    Last Post: 07-20-2018, 09:55 PM
  3. [SOLVED] how to set excel to track attendance and vacation hours available
    By vrhodes in forum Excel General
    Replies: 1
    Last Post: 02-18-2006, 08:11 PM
  4. [SOLVED] How can I track meeting attendance?
    By craezer in forum Excel - New Users/Basics
    Replies: 3
    Last Post: 02-18-2006, 07:30 PM
  5. [SOLVED] How do I track half days in the attendance tracking template?
    By Business Manager in forum Excel General
    Replies: 1
    Last Post: 10-20-2005, 03:05 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