Spreadsheet: 69369d1269911029-count-where-end-date-falls-within-range-but-non-unique-records-for-vlookup-sum-of-end-dated-in-month
Sheet: Sheet1

Staff Name | Role | PT / FT | FTE Equiv | Start Date | End Date | Reason | Start Date Value | End Date Value | 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 |  | 40179 | 73031 | Y | 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 | 40196 | 40298 | Y | 0.7 |  |  | 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 | 40299 | 40377 | Y | 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 | 40196 | 40298 | Y | 0.7 |  |  | 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 | 40299 | 40377 | Y | 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 |  | 39755 | 40250 | Y | 1 |  |  | 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 |  | 40251 | 73031 | Y | 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 |  | 39630 | 73031 | Y | 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 |  | 39630 | 73031 | Y | 0.7 |  |  | 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 |  | 39630 | 73031 | Y | 0.7 |  |  | 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 |  | 40179 | 73031 | Y | 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 |  | 39630 | 73031 | Y | 0.7 |  |  | 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 |  | 39698 | 73031 | Y | 0.7 |  |  | 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 |  | 39790 | 73031 | Y | 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 | 40196 | 40298 | Y | 0.7 |  |  | 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 |  |  | 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 |  | 39755 | 73031 | Y | 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 | 40196 | 40298 | Y | 0.7 |  |  | 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 | 40299 | 40377 | Y | 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] | 40179 | 40421 | Y | 1 |  |  | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 0 | 0 | 0 | 0
Sum of End date