| Register | FAQ | Calendar | Search | Today's Posts | Mark Forums Read |
|
#1
|
| I made an excel sheet to calculate the number of the vacation taken by the employees excluding the weekend and the official holidays. B22=From (date) > > C22= To Date > > D22= Total Taken > > C44:C53 =Official Holidays > > =NETWORKDAYS(B22,C22,C44:C53) what i do really need is to find formula that allows me to know the number of days taken in each month of the year as a summary sheet A5=NAME C5=JANUARY D5=FEBRUARY etc...... |
![]() |
| Thread Tools | |
| Display Modes | |