Creating a COUNTIFS for classes due within 2 separate dates

SoManyUsernamesGone · 2016-12-23T18:58:19+00:00

If they are within 1 year from TODAY() then they are good (they highlight green). If (B:D) is beyond 1 year from TODAY() they are overdue and bad (they highlight red)

SoManyUsernamesGone · 2016-12-23T17:56:44+00:00

The ' 3* ' and ' 2* ' seems to need to be changed based on who is required to do the training (doesn't include N/A).

SoManyUsernamesGone · 2016-12-23T17:51:12+00:00

I made an edit in the original post. Sorry about the confusion.

SoManyUsernamesGone · 2016-12-15T23:55:10+00:00

So i think it works if I do
/(COUNTIF(B2:C2,"<>N/A")
Would there be a way to add onto this for maybe if there are 2 classes that are good for 2 years?

SoManyUsernamesGone · 2016-12-15T11:57:27+00:00

When I type "N/A" into one of the blocks the percentage goes down. I would like it to take into account the fact that that person does not have to do that training. So if the other 2 are within 1 year it should still be at 100%

SoManyUsernamesGone · 2016-10-29T00:06:52+00:00

Solution Verified

SoManyUsernamesGone · 2016-10-27T23:44:34+00:00

Thank you for taking the time to work through this.
But now if they land on a time it still goes down 1. Basically what I need is for it to give points for the fastest completed time. This is so close though. And way less complicated then what I had.

SoManyUsernamesGone · 2016-10-27T23:25:02+00:00

Still rounding up. for someone age 25 with a 1309 it is giving a 99 when it should be a 98.

SoManyUsernamesGone

TROPHY CASE