Spreadsheet: 68884d1269428438-attendance-sheet-formula-not-working-please-rectify-it-attendance-sheet-complete
Sheet: Sheet1

Employees Attendance record
Branch :Lahore                                                                                                                                    Dec-09 | January 2010
Days of the week | Mon | Tue | Wed | Thu | Fri | Sat | Sun | Mon | Tue | Wed | Thu | Fri | Sat | Sun | Mon | Tue | Wed | Thu | Fri | Sat | Sun | Mon | Tue | Wed | Thu | Fri | Sat | Sun | Mon | Tue | Wed | CL | AL | CP | P | Abs
Dates | 1 | 2 | 3 | 4 | 5 | 6 | 7 | 8 | 9 | 10 | 11 | 12 | 13 | 14 | 15 | 16 | 17 | 18 | 19 | 20 | 21 | 22 | 23 | 24 | 25 | 26 | 27 | 28 | 29 | 30 | 31 |  |  |  |  |  | Dates when an employee is not present should show here. Don't show dates of blank cells.
SW
[NAME] | p | p | p | p |  |  | p | p | al | al | p | al |  | p | p | P | p | p | p | p |  | p | al | p |  |  |  |  | p | al | p | 0 | 5 | 0 | 18 | 0 | 5 | 6 | 9 | 10 | 12 | 13 | 21 | 23 | 25 | 26 | 27 | 28 | 30 | #N/A | #N/A | #N/A | #N/A | #N/A | #N/A | #N/A | #N/A | #N/A | #N/A
[NAME] | p | p | p | p |  |  |  | p | al | p | al | CL |  |  | p | p | p | p | p |  |  | p | p | p |  |  |  |  | p | p | p | 1 | 2 | 0 | 17 | 0 | 5 | 6 | 7 | 9 | 11 | 12 | 13 | 14 | 20 | 21 | 25 | 26 | 27 | 28 | #N/A | #N/A | #N/A | #N/A | #N/A | #N/A
[NAME] | p | p | p | p |  |  |  | al | p | p | p | p |  | p | p | p | p | p | p |  |  | p | p | p |  |  |  |  | p | p | p | 0 | 1 | 0 | 20 | 0 | 5 | 6 | 7 | 8 | 13 | 20 | 21 | 25 | 26 | 27 | 28 | #N/A | #N/A | #N/A | #N/A | #N/A | #N/A | #N/A | #N/A | #N/A | #N/A
[NAME] | p | p | p | p | p | p |  | cl | p | p | p | p | p |  | cl | p | p | p | p | p |  | cl | p | p |  |  |  |  | cl | p | p | 4 | 0 | 0 | 20 | 0 | 7 | 8 | 14 | 15 | 21 | 22 | 25 | 26 | 27 | 28 | 29 | #N/A | #N/A | #N/A | #N/A | #N/A | #N/A | #N/A | #N/A | #N/A | #N/A | #N/A | #N/A | #N/A
[NAME] | p | al | p | p | P |  |  | p | p | p | p | p |  |  | p | p | p | p | p |  |  | p | p | p |  |  |  |  | p | p | p | 0 | 1 | 0 | 20 | 0 | 2 | 6 | 7 | 13 | 14 | 20 | 21 | 25 | 26 | 27 | 28 | #N/A | #N/A | #N/A | #N/A | #N/A | #N/A | #N/A | #N/A | #N/A | #N/A
[NAME] | p | p | p | p |  |  | p | p | p | p | al | CL |  | p | p | p | p | p | p |  |  | CL | CL | al |  |  |  |  | CL | CL | al | 5 | 3 | 0 | 14 | 0 | 5 | 6 | 11 | 12 | 13 | 20 | 21 | 22 | 23 | 24 | 25 | 26 | 27 | 28 | 29 | 30 | 31 | #N/A | #N/A | #N/A | #N/A | #N/A
Adeel Akbar | P | p | p | p |  |  | p | p | p | p | p | p |  |  | p | p | p | p | p | p |  | p | p | p |  |  |  |  | p | p | p | 0 | 0 | 0 | 22 | 0 | 5 | 6 | 13 | 14 | 21 | 25 | 26 | 27 | 28 | #N/A | #N/A | #N/A | #N/A | #N/A | #N/A | #N/A | #N/A | #N/A | #N/A | #N/A | #N/A | #N/A
Adeel Arshad | p | p | p | p |  |  |  | p | cl | p | p | p |  |  | p | p | p | p | p |  |  | p | p | cl |  |  |  |  | p | p | cl | 3 | 0 | 0 | 17 | 0 | 5 | 6 | 7 | 9 | 13 | 14 | 20 | 21 | 24 | 25 | 26 | 27 | 28 | 31 | #N/A | #N/A | #N/A | #N/A | #N/A | #N/A
[NAME] | p | p | p | p |  |  |  | p | p | p | p | p |  |  | p | p | p | p | p |  |  | p | p | p |  |  |  |  | p | p | p | 0 | 0 | 0 | 20 | 0 | 5 | 6 | 7 | 13 | 14 | 20 | 21 | 25 | 26 | 27 | 28 | #N/A | #N/A | #N/A | #N/A | #N/A | #N/A | #N/A | #N/A | #N/A
[NAME] | p | p | p | p |  |  |  | p | p | p | p | p |  |  | p | p | p | p | p |  |  | p | p | p |  |  |  |  | p | p | p | 0 | 0 | 0 | 20 | 0 | 5 | 6 | 7 | 13 | 14 | 20 | 21 | 25 | 26 | 27 | 28 | #N/A | #N/A | #N/A | #N/A | #N/A | #N/A | #N/A | #N/A | #N/A