Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Annual Leave Summary
Hi,
I am trying to find a formula that allows me to know how many days an employee took as a vactaion on each month a summary sheet for each employee In order to find the number of days taken i have use the following : B22=From (date) C22= To Date D22= Total Taken C22:C44 =Official Holidays =NETWORKDAYS(B22,C22,C44:C53) Please advise Tia |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
Annual Leave Summary
Advise what? All you have told is what you are doing (which is inconsistent
btw, see the holiday range and the formula). I presume this doesn't work, but in what way, what should it do, etc. Is there more data than this, more info required. -- --- HTH Bob (there's no email, no snail mail, but somewhere should be gmail in my addy) "Tia" wrote in message ... Hi, I am trying to find a formula that allows me to know how many days an employee took as a vactaion on each month a summary sheet for each employee In order to find the number of days taken i have use the following : B22=From (date) C22= To Date D22= Total Taken C22:C44 =Official Holidays =NETWORKDAYS(B22,C22,C44:C53) Please advise Tia |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
Annual Leave Summary
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...... On Mar 26, 11:22*am, "Bob Phillips" wrote: Advise what? All you have told is what you are doing (which is inconsistent btw, see the holiday range and the formula). I presume this doesn't work, but in what way, what should it do, etc. Is there more data than this, more info required. -- --- HTH Bob (there's no email, no snail mail, but somewhere should be gmail in my addy) "Tia" wrote in message ... Hi, I am trying to find a formula that allows me to know how many days an employee took as a vactaion on each month a summary sheet for each employee In order to find the number of days taken i have use the following : B22=From (date) C22= To Date D22= Total Taken C22:C44 =Official Holidays =NETWORKDAYS(B22,C22,C44:C53) Please advise Tia- Hide quoted text - - Show quoted text - |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Annual leave without holidays | Excel Discussion (Misc queries) | |||
Annual leave | Excel Discussion (Misc queries) | |||
Annual Leave Planner | Excel Discussion (Misc queries) | |||
Annual Leave | Excel Discussion (Misc queries) | |||
Tracking annual leave | New Users to Excel |