| A | B | C | D | E | F | G | H | I | J | K | L | M | N | O | P | Q | R | S | T | U | V | W | X | Y | Z | AA | AB | AC | AD | AE | AF | AG | AH | AI | AJ | AK |
1 |
|
|
|
|
| Dworld |
|
|
|
|
|
|
|
|
| ||||||||||||||||||||||
2 |
|
|
|
|
| Trainig & Research Engineering & Management Institute |
|
|
|
|
|
|
|
|
| ||||||||||||||||||||||
3 |
| Month | November | 2012 |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
| ||||||||
4 | Sno | Name | 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 | Actual P | Leave P | Total P | Sallary | Grant Salary |
5 |
| Satnam Nirala | P | P | P |
| P | P | P | P | P | p |
| p |
|
|
| p | P |
| P | P | P | P | P | P |
| P | P | P | P | P | 23 | 7 | 30 | 6000 | 6000 |
6 |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
ag5 =COUNTIF(C5:AF5,"P")
ah5 =IF(OR(E5="P",G5="p"),1,0)+IF(OR(L5="P",N5="P"),1,0)+IF(OR(N5="P",R5="P"),3,0)+IF(OR(S5="P",U5="P"),1,0)+IF(OR(Z5="P",AB5="P"),1,0)
ai5 =AG5+AH5
ak5 =AJ5/30*AI5
Note - 4,11,18,25 is sunday & 13, 14, 15 is Diwali Holiday
=countif(range, criteria)
This is a free homepage created with page4. Get your own on www.page4.com