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
Bookmarks