Spreadsheet: 719097d1613500007-return-number-of-out-of-date-training-in-a-month-excel-forum-help
Sheet: matrix

 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | [NAME]
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Ruben Martin
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Aitor Garmindea
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | [NAME]
 |  |  | Months Warning | 55=SUM(IF($D$22:$D$99="END DATE",IF(TEXT(E22:E99,"mmm yyyy")="APR"(),date),1,0)))))                                     [NAME]55=IF(ISBLANK(E98),"",IF(TODAY()>=E99,5,IF(EDATE(TODAY(),Warn)>=E99,"s",IF(E98=1,"n",IF(EDATE(TODAY(),Warn)<E99,"l","")))))
n |  |  | 1
5
s | SECTION |  |  | Fork Lift Truck |  | Pedistrien Truck |  | [NAME] |  | Sissor Lift |  | Over Head Crane
 | EGE |  | Min Req
 |  |  | Plan
 | Total Associates |  | Actual
 |  |  | Gap
 | Training Valid / Years |  |  | 3 |  | 3 |  | 3 |  | 3 |  | 3 |  | 3 |  | 3 |  | 3
 | ASSOCIATE NAME | ASS NO. | DATE | STATUS |  | STATUS |  | STATUS |  | STATUS |  | STATUS |  | STATUS |  | STATUS |  | STATUS
Praxair |  |  | START DATE | 2018-02-06 00:00:00 |  |  |  |  |  |  |  | 2010-04-23 00:00:00
 |  |  | END DATE
 |  |  | START DATE | 2017-05-02 00:00:00 |  |  |  |  |  |  |  | 2010-04-23 00:00:00
 |  |  | END DATE
 |  |  | START DATE |  |  |  |  |  |  |  |  | 2010-04-23 00:00:00
 |  |  | END DATE
 |  |  | START DATE |  |  | 2009-10-07 00:00:00 |  |  |  |  |  | 2010-04-23 00:00:00
 |  |  | END DATE
 |  |  | START DATE |  |  |  |  |  |  |  |  | 2010-04-23 00:00:00
 |  |  | END DATE
 |  |  | START DATE |  |  |  |  |  |  |  |  | 2010-04-23 00:00:00
 |  |  | END DATE
 |  |  | START DATE | 2019-12-03 00:00:00 |  | 2021-02-04 00:00:00 |  |  |  |  |  | 2010-04-23 00:00:00
 |  |  | END DATE
 |  |  | START DATE |  |  |  |  |  |  |  |  | 2010-04-23 00:00:00
 |  |  | END DATE
 |  |  | START DATE |  |  |  |  |  |  |  |  | 2013-04-04 00:00:00
 |  |  | END DATE
 |  |  | START DATE |  |  |  |  |  |  |  |  | 2015-08-24 00:00:00
 |  |  | END DATE
 |  |  | START DATE |  |  |  |  |  |  |  |  | 2016-09-12 00:00:00
 |  |  | END DATE
 |  |  | START DATE |  |  |  |  |  |  |  |  | 2019-05-15 00:00:00
 |  |  | END DATE
 |  |  | START DATE | 2018-03-05 00:00:00 |  |  |  | 2018-03-09 00:00:00 |  |  |  | 2018-12-10 00:00:00
 |  |  | END DATE
 |  |  | START DATE | 2018-03-29 00:00:00 |  | 2018-05-29 00:00:00 |  |  |  |  |  | 2018-12-10 00:00:00
 |  |  | END DATE
 |  |  | START DATE |  |  |  |  |  |  |  |  | 2016-09-12 00:00:00
 |  |  | END DATE
 |  |  | START DATE |  |  |  |  |  |  |  |  | 2019-05-15 00:00:00
 |  |  | END DATE
 |  |  | START DATE |  |  |  |  |  |  |  |  | 2019-05-15 00:00:00
 |  |  | END DATE
 |  |  | START DATE |  |  |  |  |  |  |  |  | 2019-07-02 00:00:00
 |  |  | END DATE
 |  |  | START DATE | 2020-07-28 00:00:00 |  |  |  |  |  |  |  | 2019-07-02 00:00:00
 |  |  | END DATE
 |  |  | START DATE |  |  |  |  |  |  |  |  | 2010-04-23 00:00:00
 |  |  | END DATE
 |  |  | START DATE |  |  |  |  |  |  |  |  | 2010-04-23 00:00:00
 |  |  | END DATE
 |  |  | START DATE |  |  |  |  |  |  |  |  | 2010-04-23 00:00:00
 |  |  | END DATE
 |  |  | START DATE | 2019-05-02 00:00:00 |  |  |  |  |  |  |  | 2010-04-23 00:00:00
 |  |  | END DATE
 |  |  | START DATE |  |  |  |  |  |  |  |  | 2010-04-23 00:00:00
 |  |  | END DATE
 |  |  | START DATE |  |  |  |  |  |  |  |  | 2016-09-12 00:00:00
 |  |  | END DATE
 |  |  | START DATE |  |  |  |  | 2019-06-25 00:00:00 |  |  |  | 2018-12-10 00:00:00
 |  |  | END DATE
 |  |  | START DATE | 2020-08-04 00:00:00 |  |  |  |  |  |  |  | 2018-07-02 00:00:00
 |  |  | END DATE
 |  |  | START DATE |  |  |  |  |  |  |  |  | 2019-07-02 00:00:00
 |  |  | END DATE
 |  |  | START DATE
 |  |  | END DATE
 |  |  | START DATE
 |  |  | END DATE
 |  |  | START DATE |  |  |  |  |  |  |  |  | 2013-04-23 00:00:00
 |  |  | END DATE
 |  |  | START DATE |  |  |  |  | 2016-03-15 00:00:00 |  |  |  | 2013-05-08 00:00:00
 |  |  | END DATE
 |  |  | START DATE | 2018-02-06 00:00:00
 |  |  | END DATE
 |  |  | START DATE | 2018-03-05 00:00:00 |  | 2020-10-20 00:00:00
 |  |  | END DATE
 |  |  | START DATE | 2018-09-23 00:00:00 |  | 2020-10-20 00:00:00
 |  |  | END DATE
 |  |  | START DATE |  |  | 2017-02-05 00:00:00
 |  |  | END DATE
 |  |  | START DATE
 |  |  | END DATE
 |  |  | START DATE | 2018-05-25 00:00:00
 |  |  | END DATE
 |  |  | START DATE | 2018-05-06 00:00:00
 |  |  | END DATE
 | 5 | Out of Date
 | s | Due in 3 Months
 | l | Completed
 | n | Training Needed
2021 | April | April | April
 | May | May | May
 | June | June | June
 | July | July | July
 | August | August | August
 | September | September | September
 | October | October | October
 | November | November | November
 | December | December | December
 | January | January | January
 | February | February | February
 | March | March | March
Total Associates
 | 6
2007-04-16 00:00:00 |  | 2015-06-10 00:00:00 |  | 2015-09-22 00:00:00 |  | 2015-11-12 00:00:00 |  | 2015-07-06 00:00:00 |  | 2015-10-07 00:00:00 |  | 2017-10-25 00:00:00 |  | 2018-01-22 00:00:00