Spreadsheet: 831213d1685507721-calculating-eligibility-based-on-date-of-birth-and-current-month-sample-2
Sheet: Sheet2

ID | LASTNAME | FIRSTNAME | DOB | PERIOD | DEDUCTIBLE GROSS | AGE CHECK
PS0011 | DOE | [NAME] | 1955-12-31 00:00:00 | 2015-08-01 00:00:00 | 0
PS0012 | DOE | [NAME] | 1956-01-01 00:00:00 | 2015-07-01 00:00:00 | 0
PS0013 | DOE | [NAME] | 1956-01-01 00:00:00 | 2015-08-01 00:00:00 | 0
PS0014 | DOE | [NAME] | 1956-02-18 00:00:00 | 2015-07-01 00:00:00 | 7085
PS0015 | DOE | [NAME] | 1956-02-18 00:00:00 | 2015-08-01 00:00:00 | 7085
PS0016 | DOE | [NAME] | 1956-09-14 00:00:00 | 2015-07-01 00:00:00 | 9646.5
PS0017 | DOE | [NAME] | 1956-09-14 00:00:00 | 2015-08-01 00:00:00 | 9646.5
PS0018 | DOE | [NAME] | 1956-11-15 00:00:00 | 2015-07-01 00:00:00 | 10341.92
PS0019 | DOE | [NAME] | 1956-11-15 00:00:00 | 2015-08-01 00:00:00 | 10341.92
PS0020 | DOE | [NAME] | 1957-01-29 00:00:00 | 2015-07-01 00:00:00 | 4108.59
PS0021 | DOE | [NAME] | 1957-01-29 00:00:00 | 2015-08-01 00:00:00 | 3749.96
PS0022 | DOE | [NAME] | 1957-05-01 00:00:00 | 2015-07-01 00:00:00 | 7085
PS0023 | DOE | [NAME] | 1957-05-01 00:00:00 | 2015-08-01 00:00:00 | 7085
PS0024 | DOE | [NAME] | 1957-05-16 00:00:00 | 2015-07-01 00:00:00 | 2923.16
PS0025 | DOE | [NAME] | 1957-05-16 00:00:00 | 2015-08-01 00:00:00 | 2923.16
PS0026 | DOE | [NAME] | 1957-05-27 00:00:00 | 2015-07-01 00:00:00 | 9555.1
PS0027 | DOE | [NAME] | 1957-05-27 00:00:00 | 2015-08-01 00:00:00 | 9555.1
PS0028 | DOE | [NAME] | 1957-07-08 00:00:00 | 2015-07-01 00:00:00 | 15924
PS0029 | DOE | [NAME] | 1957-07-08 00:00:00 | 2015-08-01 00:00:00 | 14933.67
PS0030 | DOE | [NAME] | 1957-07-28 00:00:00 | 2015-07-01 00:00:00 | 7085
PS0031 | DOE | [NAME] | 1957-07-28 00:00:00 | 2015-08-01 00:00:00 | 7085
PS0032 | DOE | [NAME] | 1957-11-01 00:00:00 | 2015-07-01 00:00:00 | 10341.92
PS0033 | DOE | [NAME] | 1957-11-01 00:00:00 | 2015-08-01 00:00:00 | 10341.92
PS0034 | DOE | [NAME] | 1958-02-10 00:00:00 | 2015-07-01 00:00:00 | 7500
PS0035 | DOE | [NAME] | 1958-02-10 00:00:00 | 2015-08-01 00:00:00 | 7500
PS0036 | DOE | [NAME] | 1958-03-04 00:00:00 | 2015-07-01 00:00:00 | 7086.09
PS0037 | DOE | [NAME] | 1958-03-04 00:00:00 | 2015-08-01 00:00:00 | 15924
PS0038 | DOE | [NAME] | 1958-04-30 00:00:00 | 2015-07-01 00:00:00 | 15924
PS0039 | DOE | [NAME] | 1958-04-30 00:00:00 | 2015-08-01 00:00:00 | 15924
PS0040 | DOE | [NAME] | 1958-06-30 00:00:00 | 2015-07-01 00:00:00 | 15924
PS0041 | DOE | [NAME] | 1958-06-30 00:00:00 | 2015-08-01 00:00:00 | 15924
PS0042 | DOE | [NAME] | 1958-07-06 00:00:00 | 2015-07-01 00:00:00 | 2657.42
PS0043 | DOE | [NAME] | 1958-07-06 00:00:00 | 2015-08-01 00:00:00 | 2657.42
PS0044 | DOE | [NAME] | 1958-11-14 00:00:00 | 2015-07-01 00:00:00 | 7235
PS0045 | DOE | [NAME] | 1958-11-14 00:00:00 | 2015-08-01 00:00:00 | 7235
PS0046 | DOE | [NAME] | 1958-12-31 00:00:00 | 2015-07-01 00:00:00 | 8992.5
PS0047 | DOE | [NAME] | 1958-12-31 00:00:00 | 2015-08-01 00:00:00 | 8992.5
PS0048 | DOE | [NAME] | 1959-01-25 00:00:00 | 2015-07-01 00:00:00 | 14937.52
PS0049 | DOE | [NAME] | 1959-01-25 00:00:00 | 2015-08-01 00:00:00 | 14937.52
PS0050 | DOE | [NAME] | 1959-03-08 00:00:00 | 2015-08-01 00:00:00 | 2776.19
PS0051 | DOE | [NAME] | 1959-05-08 00:00:00 | 2015-07-01 00:00:00 | 2657.42
PS0052 | DOE | [NAME] | 1959-05-08 00:00:00 | 2015-08-01 00:00:00 | 2657.42
PS0053 | DOE | [NAME] | 1959-07-23 00:00:00 | 2015-07-01 00:00:00 | 8144.91
PS0054 | DOE | [NAME] | 1959-07-23 00:00:00 | 2015-08-01 00:00:00 | 8144.91
PS0055 | DOE | [NAME] | 1959-08-24 00:00:00 | 2015-07-01 00:00:00 | 5062.14
PS0056 | DOE | [NAME] | 1959-08-24 00:00:00 | 2015-08-01 00:00:00 | 5062.14
PS0057 | DOE | [NAME] | 1959-09-21 00:00:00 | 2015-07-01 00:00:00 | 2126.37
PS0058 | DOE | [NAME] | 1959-09-21 00:00:00 | 2015-08-01 00:00:00 | 2126.37
PS0059 | DOE | [NAME] | 1959-11-20 00:00:00 | 2015-07-01 00:00:00 | 3651.5
PS0060 | DOE | [NAME] | 1959-11-20 00:00:00 | 2015-08-01 00:00:00 | 3651.5
PS0061 | DOE | [NAME] | 1959-12-01 00:00:00 | 2015-07-01 00:00:00 | 15924
PS0062 | DOE | [NAME] | 1959-12-25 00:00:00 | 2015-07-01 00:00:00 | 15924
PS0063 | DOE | [NAME] | 1959-12-25 00:00:00 | 2015-08-01 00:00:00 | 15924
PS0064 | DOE | [NAME] | 1960-02-25 00:00:00 | 2015-07-01 00:00:00 | 15924
PS0065 | DOE | [NAME] | 1960-02-25 00:00:00 | 2015-08-01 00:00:00 | 15924
PS0066 | DOE | [NAME] | 1960-03-05 00:00:00 | 2015-07-01 00:00:00 | 3706.5
PS0067 | DOE | [NAME] | 1960-03-05 00:00:00 | 2015-08-01 00:00:00 | 3706.5
PS0068 | DOE | [NAME] | 1960-04-13 00:00:00 | 2015-07-01 00:00:00 | 7793.23
PS0069 | DOE | [NAME] | 1960-04-13 00:00:00 | 2015-08-01 00:00:00 | 7793.23
PS0070 | DOE | [NAME] | 1960-06-15 00:00:00 | 2015-07-01 00:00:00 | 11826.94
PS0071 | DOE | [NAME] | 1960-06-15 00:00:00 | 2015-08-01 00:00:00 | 11826.94
PS0072 | DOE | [NAME] | 1960-07-30 00:00:00 | 2015-07-01 00:00:00 | 15924
PS0073 | DOE | [NAME] | 1960-07-30 00:00:00 | 2015-08-01 00:00:00 | 15924
PS0074 | DOE | [NAME] | 1960-08-04 00:00:00 | 2015-07-01 00:00:00 | 14783.13
PS0075 | DOE | [NAME] | 1960-08-04 00:00:00 | 2015-08-01 00:00:00 | 14783.13
PS0076 | DOE | [NAME] | 1960-08-08 00:00:00 | 2015-07-01 00:00:00 | 15020.35
PS0077 | DOE | [NAME] | 1960-08-08 00:00:00 | 2015-08-01 00:00:00 | 15020.35
PS0078 | DOE | [NAME] | 1960-10-29 00:00:00 | 2015-07-01 00:00:00 | 12811.81
[NAME] | DOE | [NAME] | 1960-10-29 00:00:00 | 2015-08-01 00:00:00 | 12811.81
PS0080 | DOE | [NAME] | 1960-11-29 00:00:00 | 2015-07-01 00:00:00 | 15924
PS0081 | DOE | [NAME] | 1960-11-29 00:00:00 | 2015-08-01 00:00:00 | 15924
PS0082 | DOE | [NAME] | 1960-12-12 00:00:00 | 2015-07-01 00:00:00 | 9532.02
PS0083 | DOE | [NAME] | 1960-12-12 00:00:00 | 2015-08-01 00:00:00 | 9532.02
PS0084 | DOE | [NAME] | 1961-02-28 00:00:00 | 2015-07-01 00:00:00 | 11980.79
PS0085 | DOE | [NAME] | 1961-02-28 00:00:00 | 2015-08-01 00:00:00 | 11980.79
PS0086 | DOE | [NAME] | 1961-07-06 00:00:00 | 2015-07-01 00:00:00 | 7793.5
PS0087 | DOE | [NAME] | 1961-07-06 00:00:00 | 2015-08-01 00:00:00 | 7793.5
PS0088 | DOE | [NAME] | 1961-10-23 00:00:00 | 2015-07-01 00:00:00 | 15924
PS0089 | DOE | [NAME] | 1962-01-05 00:00:00 | 2015-07-01 00:00:00 | 10021.31
PS0090 | DOE | [NAME] | 1962-01-05 00:00:00 | 2015-08-01 00:00:00 | 10021.31
PS0091 | DOE | [NAME] | 1962-01-07 00:00:00 | 2015-07-01 00:00:00 | 9401.25
PS0092 | DOE | [NAME] | 1962-01-07 00:00:00 | 2015-08-01 00:00:00 | 9401.25
PS0093 | DOE | [NAME] | 1962-02-17 00:00:00 | 2015-07-01 00:00:00 | 15924
PS0094 | DOE | [NAME] | 1962-02-17 00:00:00 | 2015-08-01 00:00:00 | 15924
PS0095 | DOE | [NAME] | 1962-05-24 00:00:00 | 2015-07-01 00:00:00 | 9493.56
PS0096 | DOE | [NAME] | 1962-05-25 00:00:00 | 2015-07-01 00:00:00 | 15924
PS0097 | DOE | [NAME] | 1962-05-25 00:00:00 | 2015-08-01 00:00:00 | 15924
PS0098 | DOE | [NAME] | 1962-10-08 00:00:00 | 2015-07-01 00:00:00 | 2657.42
PS0099 | DOE | [NAME] | 1962-10-08 00:00:00 | 2015-08-01 00:00:00 | 2657.42
PS0100 | DOE | [NAME] | 1962-12-01 00:00:00 | 2015-07-01 00:00:00 | 15924
PS0101 | DOE | [NAME] | 1962-12-20 00:00:00 | 2015-07-01 00:00:00 | 15924
PS0102 | DOE | [NAME] | 1962-12-20 00:00:00 | 2015-08-01 00:00:00 | 7085
PS0103 | DOE | [NAME] | 1963-02-16 00:00:00 | 2015-07-01 00:00:00 | 15924
PS0104 | DOE | [NAME] | 1963-02-16 00:00:00 | 2015-08-01 00:00:00 | 15924
PS0105 | DOE | [NAME] | 1963-05-21 00:00:00 | 2015-07-01 00:00:00 | 11816.67
PS0106 | DOE | [NAME] | 1963-06-06 00:00:00 | 2015-07-01 00:00:00 | 3706.49
PS0107 | DOE | [NAME] | 1963-06-06 00:00:00 | 2015-08-01 00:00:00 | 12454.39
PS0108 | DOE | [NAME] | 1963-06-20 00:00:00 | 2015-07-01 00:00:00 | 11342.38
PS0109 | DOE | [NAME] | 1963-06-20 00:00:00 | 2015-08-01 00:00:00 | 11342.38
PS0110 | DOE | [NAME] | 1963-06-23 00:00:00 | 2015-07-01 00:00:00 | 7085
PS0111 | DOE | [NAME] | 1963-06-23 00:00:00 | 2015-08-01 00:00:00 | 7085
PS0112 | DOE | [NAME] | 1963-08-19 00:00:00 | 2015-07-01 00:00:00 | 15924
PS0113 | DOE | [NAME] | 1963-08-19 00:00:00 | 2015-08-01 00:00:00 | 15924
PS0114 | DOE | [NAME] | 1963-08-28 00:00:00 | 2015-07-01 00:00:00 | 2657.42
PS0115 | DOE | [NAME] | 1963-08-28 00:00:00 | 2015-08-01 00:00:00 | 2657.42
PS0116 | DOE | [NAME] | 1963-09-14 00:00:00 | 2015-07-01 00:00:00 | 9493.56
PS0117 | DOE | [NAME] | 1963-09-14 00:00:00 | 2015-08-01 00:00:00 | 9493.56
PS0118 | DOE | [NAME] | 1963-10-08 00:00:00 | 2015-07-01 00:00:00 | 9585.87
PS0119 | DOE | [NAME] | 1963-10-08 00:00:00 | 2015-08-01 00:00:00 | 9585.87
PS0120 | DOE | [NAME] | 1963-10-10 00:00:00 | 2015-07-01 00:00:00 | 14783
PS0121 | DOE | [NAME] | 1963-10-10 00:00:00 | 2015-07-01 00:00:00 | 8625
PS0122 | DOE | [NAME] | 1963-10-10 00:00:00 | 2015-08-01 00:00:00 | 14783
PS0123 | DOE | [NAME] | 1963-10-10 00:00:00 | 2015-08-01 00:00:00 | 8625
PS0124 | DOE | [NAME] | 1963-10-22 00:00:00 | 2015-07-01 00:00:00 | 7294.21
PS0125 | DOE | [NAME] | 1963-10-22 00:00:00 | 2015-08-01 00:00:00 | 7294.21
PS0126 | DOE | [NAME] | 1963-10-24 00:00:00 | 2015-07-01 00:00:00 | 7991.06
PS0127 | DOE | [NAME] | 1963-10-24 00:00:00 | 2015-08-01 00:00:00 | 7991.06
PS0128 | DOE | [NAME] | 1963-11-23 00:00:00 | 2015-07-01 00:00:00 | 12415.1
PS0129 | DOE | [NAME] | 1963-11-23 00:00:00 | 2015-08-01 00:00:00 | 3651.5
PS0130 | DOE | [NAME] | 1964-05-05 00:00:00 | 2015-07-01 00:00:00 | 9401.25
PS0131 | DOE | [NAME] | 1964-05-05 00:00:00 | 2015-08-01 00:00:00 | 9401.25
PS0132 | DOE | [NAME] | 1964-06-06 00:00:00 | 2015-07-01 00:00:00 | 3739.65
PS0133 | DOE | [NAME] | 1964-06-06 00:00:00 | 2015-08-01 00:00:00 | 3739.65
PS0134 | DOE | [NAME] | 1964-06-25 00:00:00 | 2015-07-01 00:00:00 | 3706.5
PS0135 | DOE | [NAME] | 1964-06-25 00:00:00 | 2015-08-01 00:00:00 | 3706.5
PS0136 | DOE | [NAME] | 1964-07-01 00:00:00 | 2015-07-01 00:00:00 | 7183.46
PS0137 | DOE | [NAME] | 1964-07-01 00:00:00 | 2015-08-01 00:00:00 | 7183.46
PS0138 | DOE | [NAME] |  | 2015-07-01 00:00:00 | 15924
PS0139 | DOE | [NAME] |  | 2015-07-01 00:00:00 | 15924
PS0140 | DOE | [NAME] |  | 2015-07-01 00:00:00 | 15924
PS0141 | DOE | [NAME] |  | 2015-07-01 00:00:00 | 15924