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

I've seen this, and variations of it, posted in several newsgroups -
it is not a good idea to multi-post.

You give no details of where your employee names are located, so are
we meant to guess how your data is laid out?

Pete

On Mar 26, 9:26*am, Tia <tia.abdelka...@gmail.com> wrote:
> 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

Im sorry for posting so many times but i give up searching it seems
that im a bad formula searcher b i dont know where to look thank you
for caring

I made an excel sheet to calculate the number of the vacation taken
by
the employees,excluding the weekend and the official holidays.
every employee has his own sheet
Here is the formula that i have used to know the total of days taken
each time :
B22=From (date)
> > C22= To Date
> > D22= Total Taken
> > C44:C53 =Official Holidays
> > =NETWORKDAYS(B22,C22,C44:C53)


what i do really want now is to find formula that allows me to know
the
number of all the vacation requested (taken) in each month of the
year
as a summary sheet
A5=NAME
C5=JANUARY
D5=FEBRUARY
etc......

For each employee in his own sheet i wana make a summary for each
month

Thank you


On Mar 26, 1:39*pm, Pete_UK <pashu...@auditel.net> wrote:
> I've seen this, and variations of it, posted in several newsgroups -
> it is not a good idea to multi-post.
>
> You give no details of where your employee names are located, so are
> we meant to guess how your data is laid out?
>
> Pete
>
> On Mar 26, 9:26*am, Tia <tia.abdelka...@gmail.com> wrote:
>
>
>
> > 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 -

How would you want to treat the situation where the From date is in
March (e.g. 28th March) and the To date is in April (e.g. 6th April),
giving 6 days leave? This is actually 2 days in March and 4 days in
April, assuming current year. Are your dates inclusive?

Pete

On Mar 26, 11:50*am, Tia <engineer.car...@gmail.com> wrote:
> Im sorry for posting so many times but i give up searching it seems
> that im a bad formula searcher b i dont know where to look thank you
> for caring
>
> I made an excel sheet to calculate the number of the vacation taken
> by
> the employees,excluding the weekend and the official holidays.
> every employee has his own sheet
> Here is the formula that i have used to know the total of days taken
> each time :
> B22=From (date)
>
> > > C22= To Date
> > > D22= Total Taken
> > > C44:C53 =Official Holidays
> > > =NETWORKDAYS(B22,C22,C44:C53)
>
> what i do really want now *is to find formula that allows me to know
> the
> number of all the vacation requested *(taken) in each month of the
> year
> as a summary sheet
> A5=NAME
> C5=JANUARY
> D5=FEBRUARY
> etc......
>
> For each employee in his own sheet i wana make a summary for each
> month
>
> Thank you
>
> On Mar 26, 1:39*pm, Pete_UK <pashu...@auditel.net> wrote:
>
>
>
> > I've seen this, and variations of it, posted in several newsgroups -
> > it is not a good idea to multi-post.
>
> > You give no details of where your employee names are located, so are
> > we meant to guess how your data is laid out?
>
> > Pete
>
> > On Mar 26, 9:26*am, Tia <tia.abdelka...@gmail.com> wrote:
>
> > > 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 -- Hide quoted text -
>
> - Show quoted text -

actually u are right but i can always divide it
Example :
Vacation taken =20/03/2008 till 05/04/2008
i will enter it as

B22 From till =C22 Total days taken =D22
B23 20/3/08 31/3/2008 6
B24 1/4/2008 05/4/2008 4

On Mar 26, 4:30*pm, Pete_UK <pashu...@auditel.net> wrote:
> How would you want to treat the situation where the From date is in
> March (e.g. 28th March) and the To date is in April (e.g. 6th April),
> giving 6 days leave? This is actually 2 days in March and 4 days in
> April, assuming current year. Are your dates inclusive?
>
> Pete
>
> On Mar 26, 11:50*am, Tia <engineer.car...@gmail.com> wrote:
>
>
>
> > Im sorry for posting so many times but i give up searching it seems
> > that im a bad formula searcher b i dont know where to look thank you
> > for caring
>
> > I made an excel sheet to calculate the number of the vacation taken
> > by
> > the employees,excluding the weekend and the official holidays.
> > every employee has his own sheet
> > Here is the formula that i have used to know the total of days taken
> > each time :
> > B22=From (date)
>
> > > > C22= To Date
> > > > D22= Total Taken
> > > > C44:C53 =Official Holidays
> > > > =NETWORKDAYS(B22,C22,C44:C53)
>
> > what i do really want now *is to find formula that allows me to know
> > the
> > number of all the vacation requested *(taken) in each month of the
> > year
> > as a summary sheet
> > A5=NAME
> > C5=JANUARY
> > D5=FEBRUARY
> > etc......
>
> > For each employee in his own sheet i wana make a summary for each
> > month
>
> > Thank you
>
> > On Mar 26, 1:39*pm, Pete_UK <pashu...@auditel.net> wrote:
>
> > > I've seen this, and variations of it, posted in several newsgroups -
> > > it is not a good idea to multi-post.
>
> > > You give no details of where your employee names are located, so are
> > > we meant to guess how your data is laid out?
>
> > > Pete
>
> > > On Mar 26, 9:26*am, Tia <tia.abdelka...@gmail.com> wrote:
>
> > > > 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 -- Hide quoted text -
>
> > - Show quoted text -- Hide quoted text -
>
> - Show quoted text -

U are actually right
but i could treat this situation by the following action (i will
always seperate 2 months or 2 different year in my data entry)

Example
Vacation date from 25/03/2008 till 05/04/2008
i will do the following:
B22 From C22= To D22= Total taken
25/03/2008 31/03/2008 5 days
01/04/2008 05/04/2008 4 days




On Mar 26, 4:30*pm, Pete_UK <pashu...@auditel.net> wrote:
> How would you want to treat the situation where the From date is in
> March (e.g. 28th March) and the To date is in April (e.g. 6th April),
> giving 6 days leave? This is actually 2 days in March and 4 days in
> April, assuming current year. Are your dates inclusive?
>
> Pete
>
> On Mar 26, 11:50*am, Tia <engineer.car...@gmail.com> wrote:
>
>
>
> > Im sorry for posting so many times but i give up searching it seems
> > that im a bad formula searcher b i dont know where to look thank you
> > for caring
>
> > I made an excel sheet to calculate the number of the vacation taken
> > by
> > the employees,excluding the weekend and the official holidays.
> > every employee has his own sheet
> > Here is the formula that i have used to know the total of days taken
> > each time :
> > B22=From (date)
>
> > > > C22= To Date
> > > > D22= Total Taken
> > > > C44:C53 =Official Holidays
> > > > =NETWORKDAYS(B22,C22,C44:C53)
>
> > what i do really want now *is to find formula that allows me to know
> > the
> > number of all the vacation requested *(taken) in each month of the
> > year
> > as a summary sheet
> > A5=NAME
> > C5=JANUARY
> > D5=FEBRUARY
> > etc......
>
> > For each employee in his own sheet i wana make a summary for each
> > month
>
> > Thank you
>
> > On Mar 26, 1:39*pm, Pete_UK <pashu...@auditel.net> wrote:
>
> > > I've seen this, and variations of it, posted in several newsgroups -
> > > it is not a good idea to multi-post.
>
> > > You give no details of where your employee names are located, so are
> > > we meant to guess how your data is laid out?
>
> > > Pete
>
> > > On Mar 26, 9:26*am, Tia <tia.abdelka...@gmail.com> wrote:
>
> > > > 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 -- Hide quoted text -
>
> > - Show quoted text -- Hide quoted text -
>
> - Show quoted text -

So in that case we can look at the From column to determine the month
in which the leave is taken?

Incidentally, are you likely to have a new workbook for another year's
leave patterns, or will you continue to use this workbook? (In which
case you will need more columns in your summary sheet or a way of
selecting the year in that sheet - which would you prefer?)

Pete

On Mar 26, 2:53*pm, Tia <tia.abdelka...@gmail.com> wrote:
> actually u are right but i can always divide it
> Example :
> Vacation taken =20/03/2008 till 05/04/2008
> i will enter it as
>
> B22 * * From * * * * * * * *till =C22 * * * * *Total days taken =D22
> B23 * * 20/3/08 * * * * * 31/3/2008 * * * * * * *6
> B24 * * 1/4/2008 * * * * 05/4/2008 * * * * * * *4
>
> On Mar 26, 4:30*pm, Pete_UK <pashu...@auditel.net> wrote:
>
>
>
> > How would you want to treat the situation where the From date is in
> > March (e.g. 28th March) and the To date is in April (e.g. 6th April),
> > giving 6 days leave? This is actually 2 days in March and 4 days in
> > April, assuming current year. Are your dates inclusive?
>
> > Pete
>
> > On Mar 26, 11:50*am, Tia <engineer.car...@gmail.com> wrote:
>
> > > Im sorry for posting so many times but i give up searching it seems
> > > that im a bad formula searcher b i dont know where to look thank you
> > > for caring
>
> > > I made an excel sheet to calculate the number of the vacation taken
> > > by
> > > the employees,excluding the weekend and the official holidays.
> > > every employee has his own sheet
> > > Here is the formula that i have used to know the total of days taken
> > > each time :
> > > B22=From (date)
>
> > > > > C22= To Date
> > > > > D22= Total Taken
> > > > > C44:C53 =Official Holidays
> > > > > =NETWORKDAYS(B22,C22,C44:C53)
>
> > > what i do really want now *is to find formula that allows me to know
> > > the
> > > number of all the vacation requested *(taken) in each month of the
> > > year
> > > as a summary sheet
> > > A5=NAME
> > > C5=JANUARY
> > > D5=FEBRUARY
> > > etc......
>
> > > For each employee in his own sheet i wana make a summary for each
> > > month
>
> > > Thank you
>
> > > On Mar 26, 1:39*pm, Pete_UK <pashu...@auditel.net> wrote:
>
> > > > I've seen this, and variations of it, posted in several newsgroups -
> > > > it is not a good idea to multi-post.
>
> > > > You give no details of where your employee names are located, so are
> > > > we meant to guess how your data is laid out?
>
> > > > Pete
>
> > > > On Mar 26, 9:26*am, Tia <tia.abdelka...@gmail.com> wrote:
>
> > > > > Hi,
>
> > > > > I am trying to find a formula that allows me to know how many daysan
> > > > > 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 -- Hide quoted text -
>
> > > - Show quoted text -- Hide quoted text -
>
> > - Show quoted text -- Hide quoted text -
>
> - Show quoted text -

I think its better to have it as an extra column in my summary sheet
Correct me if im wrong
Ex: March 07= C5
March 08=D5
right ?

if is it so thats ok

thank u in advance

On Mar 26, 5:01*pm, Pete_UK <pashu...@auditel.net> wrote:
> So in that case we can look at the From column to determine the month
> in which the leave is taken?
>
> Incidentally, are you likely to have a new workbook for another year's
> leave patterns, or will you continue to use this workbook? (In which
> case you will need more columns in your summary sheet or a way of
> selecting the year in that sheet - which would you prefer?)
>
> Pete
>
> On Mar 26, 2:53*pm, Tia <tia.abdelka...@gmail.com> wrote:
>
>
>
> > actually u are right but i can always divide it
> > Example :
> > Vacation taken =20/03/2008 till 05/04/2008
> > i will enter it as
>
> > B22 * * From * * * * * * * *till =C22 * * * * *Total days taken =D22
> > B23 * * 20/3/08 * * * * * 31/3/2008 * * * * * * *6
> > B24 * * 1/4/2008 * * * * 05/4/2008 * * * * * * * 4
>
> > On Mar 26, 4:30*pm, Pete_UK <pashu...@auditel.net> wrote:
>
> > > How would you want to treat the situation where the From date is in
> > > March (e.g. 28th March) and the To date is in April (e.g. 6th April),
> > > giving 6 days leave? This is actually 2 days in March and 4 days in
> > > April, assuming current year. Are your dates inclusive?
>
> > > Pete
>
> > > On Mar 26, 11:50*am, Tia <engineer.car...@gmail.com> wrote:
>
> > > > Im sorry for posting so many times but i give up searching it seems
> > > > that im a bad formula searcher b i dont know where to look thank you
> > > > for caring
>
> > > > I made an excel sheet to calculate the number of the vacation taken
> > > > by
> > > > the employees,excluding the weekend and the official holidays.
> > > > every employee has his own sheet
> > > > Here is the formula that i have used to know the total of days taken
> > > > each time :
> > > > B22=From (date)
>
> > > > > > C22= To Date
> > > > > > D22= Total Taken
> > > > > > C44:C53 =Official Holidays
> > > > > > =NETWORKDAYS(B22,C22,C44:C53)
>
> > > > what i do really want now *is to find formula that allows me to know
> > > > the
> > > > number of all the vacation requested *(taken) in each month of the
> > > > year
> > > > as a summary sheet
> > > > A5=NAME
> > > > C5=JANUARY
> > > > D5=FEBRUARY
> > > > etc......
>
> > > > For each employee in his own sheet i wana make a summary for each
> > > > month
>
> > > > Thank you
>
> > > > On Mar 26, 1:39*pm, Pete_UK <pashu...@auditel.net> wrote:
>
> > > > > I've seen this, and variations of it, posted in several newsgroups-
> > > > > it is not a good idea to multi-post.
>
> > > > > You give no details of where your employee names are located, so are
> > > > > we meant to guess how your data is laid out?
>
> > > > > Pete
>
> > > > > On Mar 26, 9:26*am, Tia <tia.abdelka...@gmail.com> wrote:
>
> > > > > > 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 -- Hide quoted text -
>
> > > > - Show quoted text -- Hide quoted text -
>
> > > - Show quoted text -- Hide quoted text -
>
> > - Show quoted text -- Hide quoted text -
>
> - Show quoted text -

Well, if C5 is Jan 08, you would want to continue across with Feb 08,
March 08 etc, so Jan 09 would be in cell O5, then Feb 09, March 09
etc.

I'll have a play about and get back to you later on.

Pete

On Mar 26, 3:08*pm, Tia <tia.abdelka...@gmail.com> wrote:
> I think its better to have it as an extra column in my summary sheet
> Correct me if im wrong
> Ex: March 07= C5
> March 08=D5
> right ?
>
> if is it so thats ok
>
> thank u in advance
>
> On Mar 26, 5:01*pm, Pete_UK <pashu...@auditel.net> wrote:
>
>
>
> > So in that case we can look at the From column to determine the month
> > in which the leave is taken?
>
> > Incidentally, are you likely to have a new workbook for another year's
> > leave patterns, or will you continue to use this workbook? (In which
> > case you will need more columns in your summary sheet or a way of
> > selecting the year in that sheet - which would you prefer?)
>
> > Pete
>
> > On Mar 26, 2:53*pm, Tia <tia.abdelka...@gmail.com> wrote:
>
> > > actually u are right but i can always divide it
> > > Example :
> > > Vacation taken =20/03/2008 till 05/04/2008
> > > i will enter it as
>
> > > B22 * * From * * * * * * * *till =C22 * * * * *Total days taken =D22
> > > B23 * * 20/3/08 * * * * * 31/3/2008 * * * * * * *6
> > > B24 * * 1/4/2008 * * * * 05/4/2008 * * * * * ** 4
>
> > > On Mar 26, 4:30*pm, Pete_UK <pashu...@auditel.net> wrote:
>
> > > > How would you want to treat the situation where the From date is in
> > > > March (e.g. 28th March) and the To date is in April (e.g. 6th April),
> > > > giving 6 days leave? This is actually 2 days in March and 4 days in
> > > > April, assuming current year. Are your dates inclusive?
>
> > > > Pete
>
> > > > On Mar 26, 11:50*am, Tia <engineer.car...@gmail.com> wrote:
>
> > > > > Im sorry for posting so many times but i give up searching it seems
> > > > > that im a bad formula searcher b i dont know where to look thank you
> > > > > for caring
>
> > > > > I made an excel sheet to calculate the number of the vacation taken
> > > > > by
> > > > > the employees,excluding the weekend and the official holidays.
> > > > > every employee has his own sheet
> > > > > Here is the formula that i have used to know the total of days taken
> > > > > each time :
> > > > > B22=From (date)
>
> > > > > > > C22= To Date
> > > > > > > D22= Total Taken
> > > > > > > C44:C53 =Official Holidays
> > > > > > > =NETWORKDAYS(B22,C22,C44:C53)
>
> > > > > what i do really want now *is to find formula that allows me to know
> > > > > the
> > > > > number of all the vacation requested *(taken) in each month of the
> > > > > year
> > > > > as a summary sheet
> > > > > A5=NAME
> > > > > C5=JANUARY
> > > > > D5=FEBRUARY
> > > > > etc......
>
> > > > > For each employee in his own sheet i wana make a summary for each
> > > > > month
>
> > > > > Thank you
>
> > > > > On Mar 26, 1:39*pm, Pete_UK <pashu...@auditel.net> wrote:
>
> > > > > > I've seen this, and variations of it, posted in several newsgroups -
> > > > > > it is not a good idea to multi-post.
>
> > > > > > You give no details of where your employee names are located, soare
> > > > > > we meant to guess how your data is laid out?
>
> > > > > > Pete
>
> > > > > > On Mar 26, 9:26*am, Tia <tia.abdelka...@gmail.com> wrote:
>
> > > > > > > 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 -- Hide quoted text -
>
> > > > > - Show quoted text -- Hide quoted text -
>
> > > > - Show quoted text -- Hide quoted text -
>
> > > - Show quoted text -- Hide quoted text -
>
> > - Show quoted text -- Hide quoted text -
>
> - Show quoted text -

Yes exactly

Thank you for your help
Waiting your reply
Tia


On Mar 26, 6:08*pm, Pete_UK <pashu...@auditel.net> wrote:
> Well, if C5 is Jan 08, you would want to continue across with Feb 08,
> March 08 etc, so Jan 09 would be in cell O5, then Feb 09, March 09
> etc.
>
> I'll have a play about and get back to you later on.
>
> Pete
>
> On Mar 26, 3:08*pm, Tia <tia.abdelka...@gmail.com> wrote:
>
>
>
> > I think its better to have it as an extra column in my summary sheet
> > Correct me if im wrong
> > Ex: March 07= C5
> > March 08=D5
> > right ?
>
> > if is it so thats ok
>
> > thank u in advance
>
> > On Mar 26, 5:01*pm, Pete_UK <pashu...@auditel.net> wrote:
>
> > > So in that case we can look at the From column to determine the month
> > > in which the leave is taken?
>
> > > Incidentally, are you likely to have a new workbook for another year's
> > > leave patterns, or will you continue to use this workbook? (In which
> > > case you will need more columns in your summary sheet or a way of
> > > selecting the year in that sheet - which would you prefer?)
>
> > > Pete
>
> > > On Mar 26, 2:53*pm, Tia <tia.abdelka...@gmail.com> wrote:
>
> > > > actually u are right but i can always divide it
> > > > Example :
> > > > Vacation taken =20/03/2008 till 05/04/2008
> > > > i will enter it as
>
> > > > B22 * * From * * * * * * * *till =C22 * * * * *Total days taken =D22
> > > > B23 * * 20/3/08 * * * * * 31/3/2008 * * * * * * *6
> > > > B24 * * 1/4/2008 * * * * 05/4/2008 * * * * * * * 4
>
> > > > On Mar 26, 4:30*pm, Pete_UK <pashu...@auditel.net> wrote:
>
> > > > > How would you want to treat the situation where the From date is in
> > > > > March (e.g. 28th March) and the To date is in April (e.g. 6th April),
> > > > > giving 6 days leave? This is actually 2 days in March and 4 days in
> > > > > April, assuming current year. Are your dates inclusive?
>
> > > > > Pete
>
> > > > > On Mar 26, 11:50*am, Tia <engineer.car...@gmail.com> wrote:
>
> > > > > > Im sorry for posting so many times but i give up searching it seems
> > > > > > that im a bad formula searcher b i dont know where to look thankyou
> > > > > > for caring
>
> > > > > > I made an excel sheet to calculate the number of the vacation taken
> > > > > > by
> > > > > > the employees,excluding the weekend and the official holidays.
> > > > > > every employee has his own sheet
> > > > > > Here is the formula that i have used to know the total of days taken
> > > > > > each time :
> > > > > > B22=From (date)
>
> > > > > > > > C22= To Date
> > > > > > > > D22= Total Taken
> > > > > > > > C44:C53 =Official Holidays
> > > > > > > > =NETWORKDAYS(B22,C22,C44:C53)
>
> > > > > > what i do really want now *is to find formula that allows me to know
> > > > > > the
> > > > > > number of all the vacation requested *(taken) in each month ofthe
> > > > > > year
> > > > > > as a summary sheet
> > > > > > A5=NAME
> > > > > > C5=JANUARY
> > > > > > D5=FEBRUARY
> > > > > > etc......
>
> > > > > > For each employee in his own sheet i wana make a summary for each
> > > > > > month
>
> > > > > > Thank you
>
> > > > > > On Mar 26, 1:39*pm, Pete_UK <pashu...@auditel.net> wrote:
>
> > > > > > > I've seen this, and variations of it, posted in several newsgroups -
> > > > > > > it is not a good idea to multi-post.
>
> > > > > > > You give no details of where your employee names are located, so are
> > > > > > > we meant to guess how your data is laid out?
>
> > > > > > > Pete
>
> > > > > > > On Mar 26, 9:26*am, Tia <tia.abdelka...@gmail.com> wrote:
>
> > > > > > > > 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 -- Hide quoted text -
>
> > > > > > - Show quoted text -- Hide quoted text -
>
> > > > > - Show quoted text -- Hide quoted text -
>
> > > > - Show quoted text -- Hide quoted text -
>
> > > - Show quoted text -- Hide quoted text -
>
> > - Show quoted text -- Hide quoted text -
>
> - Show quoted text -