Spreadsheet: 98220d1297216063-setting-expiry-date-with-conditional-formatting-advfilternext30days
Sheet: Sheet1

Name | CERT III | TRADE | Date of |  | Criteria >> | Name | CERT III | TRADE | Date of | Date of
PERSON 1 | NO | YES | 2011-11-23 00:00:00 | <<This is the Data |  |  |  |  | >40582 | <40612 |  | <<Click on the formulas and see what they are
PERSON 2 | NO | NO | 2011-06-29 00:00:00
PERSON 3 | NO | NO | 2011-06-11 00:00:00
PERSON 4 | NO | YES | 2011-12-26 00:00:00 |  |  | Name | CERT III | TRADE | Date of | <<This is the Answer Area.
PERSON 5 | NO | NO | 2011-03-10 00:00:00 |  |  | PERSON 9 | NO | NO | 2011-03-08 00:00:00
PERSON 6 | YES | YES | 2011-07-15 00:00:00 |  |  | PERSON 15 | NO | NO | 2011-02-26 00:00:00
PERSON 7 | NO | YES | 2011-07-31 00:00:00 |  |  | PERSON 17 | NO | NO | 2011-03-07 00:00:00
PERSON 8 | NO | NO | 2011-09-19 00:00:00 |  |  | PERSON 20 | NO | NO | 2011-02-16 00:00:00
PERSON 9 | NO | NO | 2011-03-08 00:00:00 |  |  | PERSON 47 | NO | NO | 2011-03-03 00:00:00
PERSON 10 | NO | YES | 2011-01-03 00:00:00 |  |  | PERSON 52 | NO | YES | 2011-02-17 00:00:00
PERSON 11 | NO | NO | 2011-07-31 00:00:00 |  |  | PERSON 54 | YES | YES | 2011-03-04 00:00:00
PERSON 12 | YES | YES | 2011-12-03 00:00:00 |  |  | PERSON 67 | NO | YES | 2011-03-06 00:00:00
PERSON 13 | NO | YES | 2011-10-18 00:00:00
PERSON 14 | NO | NO | 2011-12-10 00:00:00
PERSON 15 | NO | NO | 2011-02-26 00:00:00
PERSON 16 | NO | YES | 2011-12-05 00:00:00
PERSON 17 | NO | NO | 2011-03-07 00:00:00
PERSON 18 | YES | YES | 2011-11-09 00:00:00
PERSON 19 | NO | YES | 2011-01-31 00:00:00
PERSON 20 | NO | NO | 2011-02-16 00:00:00
PERSON 21 | NO | NO | 2011-05-07 00:00:00
PERSON 22 | NO | YES | 2011-08-25 00:00:00
PERSON 23 | NO | NO | 2011-09-26 00:00:00
PERSON 24 | YES | YES | 2011-08-21 00:00:00
PERSON 25 | NO | YES | 2011-11-05 00:00:00
PERSON 26 | NO | NO | 2011-01-16 00:00:00
PERSON 27 | NO | NO | 2011-06-08 00:00:00
PERSON 28 | NO | YES | 2011-05-23 00:00:00
PERSON 29 | NO | NO | 2011-01-10 00:00:00
PERSON 30 | YES | YES | 2011-11-21 00:00:00
PERSON 31 | NO | YES | 2011-07-04 00:00:00
PERSON 32 | NO | NO | 2011-08-07 00:00:00
PERSON 33 | NO | NO | 2011-08-14 00:00:00
PERSON 34 | NO | YES | 2011-10-13 00:00:00
PERSON 35 | NO | NO | 2011-07-12 00:00:00
PERSON 36 | YES | YES | 2011-01-07 00:00:00
PERSON 37 | NO | YES | 2011-10-31 00:00:00
PERSON 38 | NO | NO | 2011-09-09 00:00:00
PERSON 39 | NO | NO | 2011-03-20 00:00:00
PERSON 40 | NO | YES | 2011-08-30 00:00:00
PERSON 41 | NO | NO | 2011-10-06 00:00:00
PERSON 42 | YES | YES | 2011-06-09 00:00:00
PERSON 43 | NO | YES | 2011-08-03 00:00:00
PERSON 44 | NO | NO | 2011-12-28 00:00:00
PERSON 45 | NO | NO | 2011-01-10 00:00:00
PERSON 46 | NO | YES | 2011-04-08 00:00:00
PERSON 47 | NO | NO | 2011-03-03 00:00:00
PERSON 48 | YES | YES | 2011-07-17 00:00:00
PERSON 49 | NO | YES | 2011-12-08 00:00:00
PERSON 50 | NO | NO | 2011-11-24 00:00:00
PERSON 51 | NO | NO | 2011-10-21 00:00:00
PERSON 52 | NO | YES | 2011-02-17 00:00:00
PERSON 53 | NO | NO | 2011-06-24 00:00:00
PERSON 54 | YES | YES | 2011-03-04 00:00:00
PERSON 55 | NO | YES | 2011-04-12 00:00:00
PERSON 56 | NO | NO | 2011-05-01 00:00:00
PERSON 57 | NO | NO | 2011-01-31 00:00:00
PERSON 58 | NO | YES | 2011-06-11 00:00:00
PERSON 59 | NO | NO | 2011-01-15 00:00:00
PERSON 60 | YES | YES | 2011-08-22 00:00:00
PERSON 61 | NO | YES | 2011-05-07 00:00:00
PERSON 62 | NO | NO | 2011-01-24 00:00:00
PERSON 63 | NO | NO | 2011-09-09 00:00:00
PERSON 64 | NO | YES | 2011-11-26 00:00:00
PERSON 65 | NO | NO | 2011-11-20 00:00:00
PERSON 66 | YES | YES | 2011-06-29 00:00:00
PERSON 67 | NO | YES | 2011-03-06 00:00:00
PERSON 68 | NO | NO | 2011-12-22 00:00:00
PERSON 69 | NO | NO | 2011-01-15 00:00:00
PERSON 70 | NO | YES | 2011-12-12 00:00:00
PERSON 71 | NO | NO | 2011-12-07 00:00:00
PERSON 72 | YES | YES | 2011-05-26 00:00:00
PERSON 73 | NO | YES | 2011-05-26 00:00:00
PERSON 74 | NO | NO | 2011-12-13 00:00:00
PERSON 75 | NO | NO | 2011-03-20 00:00:00
PERSON 76 | NO | YES | 2011-11-09 00:00:00
PERSON 77 | NO | NO | 2011-05-15 00:00:00
PERSON 78 | YES | YES | 2011-07-01 00:00:00
PERSON 79 | NO | YES | 2011-05-24 00:00:00
PERSON 80 | NO | NO | 2011-12-31 00:00:00
PERSON 81 | NO | NO | 2011-12-28 00:00:00
PERSON 82 | NO | YES | 2011-07-14 00:00:00
PERSON 83 | NO | NO | 2011-12-15 00:00:00
PERSON 84 | YES | YES | 2011-07-07 00:00:00
PERSON 85 | NO | YES | 2011-11-16 00:00:00
PERSON 86 | NO | NO | 2011-04-06 00:00:00
PERSON 87 | NO | NO | 2011-09-06 00:00:00
PERSON 88 | NO | YES | 2011-07-03 00:00:00
PERSON 89 | NO | NO | 2011-02-02 00:00:00
PERSON 90 | YES | YES | 2011-11-01 00:00:00
PERSON 91 | NO | YES | 2011-01-15 00:00:00
PERSON 92 | NO | NO | 2011-11-20 00:00:00
PERSON 93 | NO | NO | 2011-10-12 00:00:00
PERSON 94 | NO | YES | 2011-07-18 00:00:00
PERSON 95 | NO | NO | 2011-02-01 00:00:00
PERSON 96 | YES | YES | 2011-10-28 00:00:00
PERSON 97 | NO | NO | 2011-07-30 00:00:00
PERSON 98 | NO | YES | 2011-02-05 00:00:00
PERSON 99 | NO | NO | 2011-09-14 00:00:00
PERSON 100 | YES | YES | 2011-04-17 00:00:00