Results 1 to 21 of 21

How can I automatically subtract a number based on previous 90 days (attendance tracker)

Threaded View

Formulation How can I automatically... 08-07-2017, 02:27 PM
JohnTopley Re: How can I automatically... 08-07-2017, 03:09 PM
Formulation Re: How can I automatically... 08-07-2017, 03:23 PM
JeteMc Re: How can I automatically... 08-07-2017, 08:12 PM
Formulation Re: How can I automatically... 08-08-2017, 10:55 AM
FlameRetired Re: How can I automatically... 08-08-2017, 12:11 AM
FlameRetired Re: How can I automatically... 08-08-2017, 01:46 AM
JeteMc Re: How can I automatically... 08-08-2017, 05:10 PM
Formulation Re: How can I automatically... 08-10-2017, 09:47 AM
JeteMc Re: How can I automatically... 08-10-2017, 10:00 AM
Formulation Re: Advanced attendance... 08-15-2017, 09:00 AM
Formulation Re: How can I automatically... 08-15-2017, 03:57 PM
JeteMc Re: How can I automatically... 08-15-2017, 04:57 PM
Formulation Re: How can I automatically... 08-15-2017, 05:07 PM
JeteMc Re: How can I automatically... 08-15-2017, 05:53 PM
Formulation Re: How can I automatically... 08-16-2017, 08:58 AM
Formulation Re: How can I automatically... 08-18-2017, 08:49 AM
Formulation Re: How can I automatically... 08-21-2017, 09:30 AM
JeteMc Re: How can I automatically... 08-21-2017, 10:54 AM
Formulation Re: How can I automatically... 09-14-2017, 09:42 AM
Formulation Re: How can I automatically... 09-15-2017, 12:51 PM
  1. #11
    Registered User
    Join Date
    08-26-2016
    Location
    usa
    MS-Off Ver
    14.0.4760.1000
    Posts
    25

    Lightbulb Re: Advanced attendance tracker setup

    I'm attempting to fix one small issue that I hope one of you gurus can figure out. (latest copy is attached)

    At the moment if someone starts the year with 0 points and goes 180 days with perfect attendance, they still have 0 points.
    However, those two 90 day periods of perfect attendance do not need to count.

    For instance, Jan 1st = 0 points. Perfect attendance for 180 days. Then in August they call off (1 point). They should still only have 1 point until 90 days perfect attendance past the date of the call off in August.

    If they start the year with 1 point, go 180 days with perfect attendance, they should have 0 points since the minimum is set to 0(that part works). Now if they get a point in say October their total should be 1 point. Currently it's taking into account the 180 days of perfect attendance at the beginning of the year and subtracting 1 point (it shouldn't do that).
    Attached Files Attached Files
    Last edited by Formulation; 08-15-2017 at 05:06 PM.

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. Replies: 11
    Last Post: 11-02-2016, 09:52 AM
  2. Replies: 0
    Last Post: 09-16-2016, 08:54 AM
  3. Replies: 1
    Last Post: 10-24-2014, 09:57 PM
  4. Formula to look back 90 days and drop point on attendance tracker
    By tmorr24 in forum Excel Formulas & Functions
    Replies: 3
    Last Post: 09-22-2014, 01:27 AM
  5. [SOLVED] Subtract Two Dates By The Number of Days, But Only Inlcude Work Days
    By ptho16 in forum Excel Formulas & Functions
    Replies: 1
    Last Post: 08-16-2012, 11:31 AM
  6. Generating the next number automatically based on a previous cell value
    By hpfeiffer in forum Excel Formulas & Functions
    Replies: 4
    Last Post: 06-04-2012, 03:04 AM
  7. [SOLVED] Subtract # of days from date, but if not sat, goto previous sat?
    By Fernando in forum Excel General
    Replies: 3
    Last Post: 05-01-2006, 03:57 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