Annual Leave Summary

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

Tia - 26 Mar 2008 10:01 GMT

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

Reply to this Message

Bob Phillips - 26 Mar 2008 10:22 GMT

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.

Signature

---
HTH

Bob

(there's no email, no snail mail, but somewhere should be gmail in my addy)

> Hi,
>
[quoted text clipped - 11 lines]
> Please advise
> Tia

Reply to this Message

Tia - 26 Mar 2008 10:48 GMT

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......

> 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,
[quoted text clipped - 26 lines]
>
> - Show quoted text -

Reply to this Message