Spreadsheet: 69384d1269929974-count-where-end-date-falls-within-range-but-non-unique-records-for-vlookup-testdarren
Sheet: Sheet1

Staff Name | Role | PT / FT | FTE Equiv | Start Date | End Date | Reason | Included | [NAME] |  | 2010-01-15 00:00:00 | 2010-02-15 00:00:00 | 2010-03-15 00:00:00 | 2010-04-15 00:00:00 | 2010-05-15 00:00:00 | 2010-06-15 00:00:00 | 2010-07-15 00:00:00 | 2010-08-15 00:00:00 | 2010-09-15 00:00:00 | 2010-10-15 00:00:00 | 2010-11-15 00:00:00 | 2010-12-15 00:00:00
ALFORD, [NAME] | CAPP | FT | 1 | 2010-01-01 00:00:00 | 2099-12-12 00:00:00 |  | Y | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1
ATKINS, [NAME] | Inbound | PT | 0.7 | 2010-01-18 00:00:00 | 2010-04-30 00:00:00 | Fixed Term Contract | Y | 0.7 | 1 | 0 | 0.7 | 0.7 | 0.7 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
ATKINS, [NAME] | Inbound | FT | 1 | 2010-05-01 00:00:00 | 2010-07-18 00:00:00 | Fixed Term Contract | Y | 1 | 1 | 0 | 0 | 0 | 0 | 1 | 1 | 1 | 0 | 0 | 0 | 0 | 0
AVENELL, Shane | Inbound | PT | 0.7 | 2010-01-18 00:00:00 | 2010-04-30 00:00:00 | Fixed Term Contract | Y | 0.7 | 1 | 0 | 0.7 | 0.7 | 0.7 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
AVENELL, Shane | Inbound | FT | 1 | 2010-05-01 00:00:00 | 2010-07-18 00:00:00 | Fixed Term Contract | Y | 1 | 1 | 0 | 0 | 0 | 0 | 1 | 1 | 1 | 0 | 0 | 0 | 0 | 0
[NAME], [NAME] | Inbound | FT | 1 | 2008-11-03 00:00:00 | 2010-03-13 00:00:00 |  | Y | 1 | 0 | 1 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
[NAME], [NAME] | PAD - Priority Assistance Desk | FT | 1 | 2010-03-14 00:00:00 | 2099-12-12 00:00:00 |  | Y | 1 | 1 | 0 | 0 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1
[NAME], [NAME] | Flight Change | FT | 1 | 2008-07-01 00:00:00 | 2099-12-12 00:00:00 |  | Y | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1
BALL, [NAME] | [NAME] | PT | 0.7 | 2008-07-01 00:00:00 | 2099-12-12 00:00:00 |  | Y | 0.7 | 1 | 0.7 | 0.7 | 0.7 | 0.7 | 0.7 | 0.7 | 0.7 | 0.7 | 0.7 | 0.7 | 0.7 | 0.7
BATTERSBY, [NAME] | Inbound | PT | 0.7 | 2008-07-01 00:00:00 | 2099-12-12 00:00:00 |  | Y | 0.7 | 1 | 0.7 | 0.7 | 0.7 | 0.7 | 0.7 | 0.7 | 0.7 | 0.7 | 0.7 | 0.7 | 0.7 | 0.7
BEHRENS, [NAME] | Team Leader - BH | FT | 1 | 2010-01-01 00:00:00 | 2099-12-12 00:00:00 |  | Y | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1
BELLEW, Belinda | Inbound | PT | 0.7 | 2008-07-01 00:00:00 | 2099-12-12 00:00:00 |  | Y | 0.7 | 1 | 0.7 | 0.7 | 0.7 | 0.7 | 0.7 | 0.7 | 0.7 | 0.7 | 0.7 | 0.7 | 0.7 | 0.7
BELLEW, [NAME] | Inbound | PT | 0.7 | 2008-09-07 00:00:00 | 2099-12-12 00:00:00 |  | Y | 0.7 | 0 | 0.7 | 0.7 | 0.7 | 0.7 | 0.7 | 0.7 | 0.7 | 0.7 | 0.7 | 0.7 | 0.7 | 0.7
BENNETT, Joel | Inbound | FT | 1 | 2008-12-08 00:00:00 | 2099-12-12 00:00:00 |  | Y | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1
BEST, [NAME] | Inbound | PT | 0.7 | 2010-01-18 00:00:00 | 2010-04-30 00:00:00 | Fixed Term Contract | Y | 0.7 | 1 | 0 | 0.7 | 0.7 | 0.7 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
BEST, [NAME] | Inbound | FT | 1 | 2010-05-01 00:00:00 | 2010-07-18 00:00:00 |  | Y | 1 | 1 | 0 | 0 | 0 | 0 | 1 | 1 | 1 | 0 | 0 | 0 | 0 | 0
BEVERIDGE, Julian | Inbound | FT | 1 | 2008-11-03 00:00:00 | 2099-12-12 00:00:00 |  | Y | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1
BIGGS, [NAME] | Inbound | PT | 0.7 | 2010-01-18 00:00:00 | 2010-04-30 00:00:00 | Fixed Term Contract | Y | 0.7 | 1 | 0 | 0.7 | 0.7 | 0.7 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
BIGGS, [NAME] | Inbound | FT | 1 | 2010-05-01 00:00:00 | 2010-07-18 00:00:00 | Fixed Term Contract | Y | 1 | 1 | 0 | 0 | 0 | 0 | 1 | 1 | 1 | 0 | 0 | 0 | 0 | 0
BLANCHARD, Bryony | [NAME] | FT | 1 | 2010-01-01 00:00:00 | 2010-08-31 00:00:00 | [NAME] | Y | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 0 | 0 | 0 | 0
Sum of End date |  |  |  |  |  |  |  |  |  | 8.100000000000001 | 10.9 | 11.9