Spreadsheet: 297938d1392652380-nesting-if-functions-using-eomonth-nested-eomonth-2-
Sheet: Sheet1

Awarding Body |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | SFC Funding Value
ABC |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 315
HABC |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 390
Pearson EDI |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 690
OCR
NCFE |  | Enrolement plus 6 months | 2014-02-17 00:00:00 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 870
 |  | Enrolement plus 8 months
 |  | Enrolement plus 13 months |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 1200
Yes
No
 |  | Skills_For_Care | HSC_L5
 |  | Skills_For_Care | SFC (for [NAME]) | Calderdale | Calderdale (For [NAME]) | Skills_Funding_Agency | West_Notts_College | Civil_Nuclear_Constabulary | North_Notts_College | Seetec | Acton_Training_Centre
 |  | HSC_L2 | 6 Months | [NAME] | 3 Months | SFA 1 | WNC 1 | CNC 1 | NNC 1 | Seetec 1 | [NAME]
 |  | [NAME] | 8 Months | BA L2 | 4 Months | SFA 2 | WNC 2 | CNC 2 | NNC 2 | Seetec 2 | [NAME]
 |  | HSC_L5 | 13 Months | HSC L2 | 6 Months | SFA 3 | WNC 3 | CNC 3 | NNC 3 | Seetec 3 | [NAME]
 |  |  |  | HSC L3 | 8 Months | SFA 4 | WNC 4 | CNC 4 | NNC 4 | Seetec 4 | [NAME]
 |  |  |  |  |  | SFA 5 | WNC 5 | CNC 5 | NNC 5 | Seetec 5 | [NAME]
 |  |  |  |  |  | SFA 6 | WNC 6 | CNC 6 | NNC 6 | Seetec 6 | [NAME] 6
 |  |  |  |  |  | SFA 7 | WNC 7 | CNC 7 | NNC 7 | Seetec 7 | [NAME]
 |  |  |  |  |  | SFA 8 | WNC 8 | CNC 8 | NNC 8 | Seetec 8 | [NAME] 8
 |  |  |  |  |  | SFA 9 | WNC 9 | CNC 9 | NNC 9 | Seetec 9 | [NAME] 9 |  |  |  |  |  |  |  |  |  |  |  | 0.01
 |  |  |  |  |  | SFA 10 | WNC 10 | CNC 10 | NNC 10 | Seetec 10 | [NAME] 10 |  |  |  |  |  |  |  |  |  |  |  | 0.01
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Skills Funding Agency Funding Value
 |  | SFC (OLD LIST)
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 0.01
 |  | Dementia Care (QCF) Level 3 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 0.01
 |  | Working in End of Life Care. Level 3 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 0.01
 |  | Health and Social Care (Adults) England (QCF) Level 2 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 0.01
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 0.01
 |  | Health and Social Care (Adults) England (QCF) Level 3
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | West Notts College Funding Value
 |  | Leadership in Health and Social Care and Children and Young peoples Services. Level 5
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 0.01
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 0.01
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 0.01
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 0.01
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 0.01
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | CNC Funding Value
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 0.01
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 0.01
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 0.01
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 0.01
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 0.01
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | North Notts College Funding Agency
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 0.01
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 0.01
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 0.01
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 0.01
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 0.01
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Seetec Funding Agency
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 0.01
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 0.01
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 0.01
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 0.01
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 0.01