All trying to create a formula to calculate attendance where we have the raw data in the below mentioned sequence:
Code Date status
SAM 07-06 PRESENT
SAM 07-07 ABSENT
SAM 07-08 HALF DAY

NOW THE TRACKER IS IN THE FOLLOWING FORMAT
CODE 07-06 | 07-07 |07-08

NOW I NEED A FORMULA WHICH WILL EXTRACT INFORMATION FOR THE CODE FOR THE DATES IN INCREMENT