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. #1
    Registered User
    Join Date
    08-26-2016
    Location
    usa
    MS-Off Ver
    14.0.4760.1000
    Posts
    25

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

    I've attached a sample sheet. Thanks for anyone who can help!

    I have created an attendance tracker which currently adds up points for instances of tardy, call off, etc... I have a formula set to only add points to the total if they were in the previous 12 months.

    My question is, I need one last thing added and that is a way to remove 1 point from the total points if they have not been tardy, called out in the last 90 days.

    Currently the total points (in the last 12 months) is totaled for each employee starting in Cell H6
    If there has been 90 days of no entries (days start in I6 - all the way to the right), I would like to subtract 1 point from the total in column H.

    For example, today is August 7th, 2017. If the previous 90 days (May 9th-August 7th) has empty cells, remove 1 point from the total.

    I will have to ignore all future dates as they can not be factored into the 90 day period.
    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. 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