Hello,

I am trying to get a formula that will calculate the number of workdays
(Monday to Friday) between two dates in the following format - if possible
this will also take into account a specified list of holidays (non-workdays),
e.g. 25/12/08, which I can specify in a list.

This will always revolve around date 1 - so if date 2 is after date 1 it
will be a positive number, if date 2 is before date one, it will be a
negative number

For example:

Date 1 Date2 No of working
days from date 1

Monday 2nd Feb Friday 30th Jan -1
Monday 2nd Feb Wednesday 4th Feb 2
Monday 2nd Feb Monday 9th Feb 5


Many thanks.

Bob

Use the =NETWORKDAYS(Start_Date,End_Date,[Holidays])

Holidays are an optional entry, where start and end dates are required.
--
Kevin Backmann


"Bob Freeman" wrote:

Hello,

I am trying to get a formula that will calculate the number of workdays
(Monday to Friday) between two dates in the following format - if possible
this will also take into account a specified list of holidays (non-workdays),
e.g. 25/12/08, which I can specify in a list.

This will always revolve around date 1 - so if date 2 is after date 1 it
will be a positive number, if date 2 is before date one, it will be a
negative number

For example:

Date 1 Date2 No of working
days from date 1

Monday 2nd Feb Friday 30th Jan -1
Monday 2nd Feb Wednesday 4th Feb 2
Monday 2nd Feb Monday 9th Feb 5


Many thanks.

Bob

=WORKDAYS(A2,B2,holidays)

where holidays is a range of holiday dates

--
__________________________________
HTH

Bob

"Bob Freeman" wrote in message
...
Hello,

I am trying to get a formula that will calculate the number of workdays
(Monday to Friday) between two dates in the following format - if possible
this will also take into account a specified list of holidays
(non-workdays),
e.g. 25/12/08, which I can specify in a list.

This will always revolve around date 1 - so if date 2 is after date 1 it
will be a positive number, if date 2 is before date one, it will be a
negative number

For example:

Date 1 Date2 No of
working
days from date 1

Monday 2nd Feb Friday 30th Jan -1
Monday 2nd Feb Wednesday 4th Feb 2
Monday 2nd Feb Monday 9th Feb 5


Many thanks.

Bob

Hi,

Networkdays would normally give an answer 1 higher than you are asking for
so perhaps this

=IF(B1<A1,networkdays(A1,B1,Holidays)+1,networkday s(A1,B1,Holidays)-1)

If your results are an error or typo use the simpler

=networkdays(A1,B1,Holidays)

Holidays is a named range containing holiday dates. If you get a NAM error
then
Tools|Addins and load the analysis toolpak.

Mike

"Bob Freeman" wrote:

Hello,

I am trying to get a formula that will calculate the number of workdays
(Monday to Friday) between two dates in the following format - if possible
this will also take into account a specified list of holidays (non-workdays),
e.g. 25/12/08, which I can specify in a list.

This will always revolve around date 1 - so if date 2 is after date 1 it
will be a positive number, if date 2 is before date one, it will be a
negative number

For example:

Date 1 Date2 No of working
days from date 1

Monday 2nd Feb Friday 30th Jan -1
Monday 2nd Feb Wednesday 4th Feb 2
Monday 2nd Feb Monday 9th Feb 5


Many thanks.

Bob

Thanks Mike - this is great

"Mike H" wrote:

Hi,

Networkdays would normally give an answer 1 higher than you are asking for
so perhaps this

=IF(B1<A1,networkdays(A1,B1,Holidays)+1,networkday s(A1,B1,Holidays)-1)

If your results are an error or typo use the simpler

=networkdays(A1,B1,Holidays)

Holidays is a named range containing holiday dates. If you get a NAM error
then
Tools|Addins and load the analysis toolpak.

Mike

"Bob Freeman" wrote:

Hello,

I am trying to get a formula that will calculate the number of workdays
(Monday to Friday) between two dates in the following format - if possible
this will also take into account a specified list of holidays (non-workdays),
e.g. 25/12/08, which I can specify in a list.

This will always revolve around date 1 - so if date 2 is after date 1 it
will be a positive number, if date 2 is before date one, it will be a
negative number

For example:

Date 1 Date2 No of working
days from date 1

Monday 2nd Feb Friday 30th Jan -1
Monday 2nd Feb Wednesday 4th Feb 2
Monday 2nd Feb Monday 9th Feb 5


Many thanks.

Bob

Thank you

"Kevin B" wrote:

Use the =NETWORKDAYS(Start_Date,End_Date,[Holidays])

Holidays are an optional entry, where start and end dates are required.
--
Kevin Backmann


"Bob Freeman" wrote:

Hello,

I am trying to get a formula that will calculate the number of workdays
(Monday to Friday) between two dates in the following format - if possible
this will also take into account a specified list of holidays (non-workdays),
e.g. 25/12/08, which I can specify in a list.

This will always revolve around date 1 - so if date 2 is after date 1 it
will be a positive number, if date 2 is before date one, it will be a
negative number

For example:

Date 1 Date2 No of working
days from date 1

Monday 2nd Feb Friday 30th Jan -1
Monday 2nd Feb Wednesday 4th Feb 2
Monday 2nd Feb Monday 9th Feb 5


Many thanks.

Bob

Thank you

"Bob Phillips" wrote:

=WORKDAYS(A2,B2,holidays)

where holidays is a range of holiday dates

--
__________________________________
HTH

Bob

"Bob Freeman" wrote in message
...
Hello,

I am trying to get a formula that will calculate the number of workdays
(Monday to Friday) between two dates in the following format - if possible
this will also take into account a specified list of holidays
(non-workdays),
e.g. 25/12/08, which I can specify in a list.

This will always revolve around date 1 - so if date 2 is after date 1 it
will be a positive number, if date 2 is before date one, it will be a
negative number

For example:

Date 1 Date2 No of
working
days from date 1

Monday 2nd Feb Friday 30th Jan -1
Monday 2nd Feb Wednesday 4th Feb 2
Monday 2nd Feb Monday 9th Feb 5


Many thanks.

Bob