But not working properly
My employee number 001 worked for 26 days and it took 5 days leave. according
to payble leave of 3 days its total working days should be 29. but formula given by you is returning 24. So pls once again chekc and give solution. Thanks and regards. yours RRS |
But not working properly
I think YOU should state the correct calculation.
Based on Bob's formula: =SUM(E3:AI3)/8+3-COUNTIF(E3:AI3,"A") 26 working days (SUM(A3:A13)/8) 3 Payable leave days (3) 5 leave days (COUNTIF(E3:E13,"A")) will give answer of 24. If this is not the calculation, then what is it? "Rao Ratan Singh" wrote: My employee number 001 worked for 26 days and it took 5 days leave. according to payble leave of 3 days its total working days should be 29. but formula given by you is returning 24. So pls once again chekc and give solution. Thanks and regards. yours RRS |
But not working properly
Rao,
Bob's formula is perfectly working for your calculations. I got 29. But it should be fine tuned for the month of February when there are 28 or 29 days. Jaleel "Rao Ratan Singh" wrote: My employee number 001 worked for 26 days and it took 5 days leave. according to payble leave of 3 days its total working days should be 29. but formula given by you is returning 24. So pls once again chekc and give solution. Thanks and regards. yours RRS |
All times are GMT +1. The time now is 05:58 AM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com