using NETWORKDAYS
 

Does anyone know if I can take a date use the NETWORKDAYS function to count
forward a specified number of days

for example If I were to take 1st March and count forward 10 network days I
would get an answer of 14th March

If using NETWORKDAYS won't work does anyone know of anything else I can use?

Sorry, been playing with this for ages trying to see if this could work and
just can't seem to be able to do it!
--
Kind regards
Mandy

using NETWORKDAYS
 

On Tue, 1 May 2007 09:19:02 -0700, mandy
wrote:

Does anyone know if I can take a date use the NETWORKDAYS function to count
forward a specified number of days

for example If I were to take 1st March and count forward 10 network days I
would get an answer of 14th March

If using NETWORKDAYS won't work does anyone know of anything else I can use?

Sorry, been playing with this for ages trying to see if this could work and
just can't seem to be able to do it!

Look at the WORKDAY function.
--ron

using NETWORKDAYS
 

If using NETWORKDAYS won't work does anyone know of anything else I can use?

To get this function to work, you may have to enable:
Tools....Add-ins.... enable "Analysis ToolPak - VBA".
(http://support.microsoft.com/kb/259200 suggests you enable "Analysis
ToolPak", but if doesn't work for me without enabling the "- VBA"
one).

HTH

Andrew

using NETWORKDAYS
 

Thank you so much - knew there had to be an answer out there. Don't suppose
you know of any easy way of telling it to ignore every wednesday, for
example? It'll take for ever to enter all the dates ....

cheers

--
Kind regards
Mandy


"Ron Rosenfeld" wrote:

On Tue, 1 May 2007 09:19:02 -0700, mandy
wrote:

Does anyone know if I can take a date use the NETWORKDAYS function to count
forward a specified number of days

for example If I were to take 1st March and count forward 10 network days I
would get an answer of 14th March

If using NETWORKDAYS won't work does anyone know of anything else I can use?

Sorry, been playing with this for ages trying to see if this could work and
just can't seem to be able to do it!

Look at the WORKDAY function.
--ron

using NETWORKDAYS
 

On Tue, 1 May 2007 09:40:00 -0700, mandy
wrote:

Thank you so much - knew there had to be an answer out there. Don't suppose
you know of any easy way of telling it to ignore every wednesday, for
example? It'll take for ever to enter all the dates ....

cheers

You'll need a different function. Do you want a function that ignores ONLY
Wednesday's; or do you need a function that ignores Saturday, Sunday, Wednesday
and Holidays?
--ron

using NETWORKDAYS
 

On May 1, 5:40 pm, mandy wrote:
Thank you so much - knew there had to be an answer out there. Don't suppose
you know of any easy way of telling it to ignore every wednesday, for
example? It'll take for ever to enter all the dates ....

cheers

--
Kind regards
Mandy

"Ron Rosenfeld" wrote:
On Tue, 1 May 2007 09:19:02 -0700, mandy
wrote:

Does anyone know if I can take a date use the NETWORKDAYS function to count
forward a specified number of days

for example If I were to take 1st March and count forward 10 network days I
would get an answer of 14th March

If using NETWORKDAYS won't work does anyone know of anything else I can use?

Sorry, been playing with this for ages trying to see if this could work and
just can't seem to be able to do it!

Look at the WORKDAY function.
--ron

No, but here's a workaround:
=networkdays(A1,B1,C1:C100)

Put startdate in A1 enddate in B1, and list of days you want to ignore
in C1:C100.

To create a list of all wednesdays (for putting into C1:C100):
Start with a Wednesday in C1, using a calendar. e.g. 02/05/2007 (UK
date format).
In C2, use =C1+7.
Copy the formula down.

HTH

Andrew

using NETWORKDAYS
 

the latter - one that I can specify which other days to ignore.

Thanks for the help, really appreciate it
--
Kind regards
Mandy


"Ron Rosenfeld" wrote:

On Tue, 1 May 2007 09:40:00 -0700, mandy
wrote:

Thank you so much - knew there had to be an answer out there. Don't suppose
you know of any easy way of telling it to ignore every wednesday, for
example? It'll take for ever to enter all the dates ....

cheers

You'll need a different function. Do you want a function that ignores ONLY
Wednesday's; or do you need a function that ignores Saturday, Sunday, Wednesday
and Holidays?
--ron

using NETWORKDAYS
 

Superb - thanks for your help!
--
Kind regards
Mandy


"loudfish" wrote:

On May 1, 5:40 pm, mandy wrote:
Thank you so much - knew there had to be an answer out there. Don't suppose
you know of any easy way of telling it to ignore every wednesday, for
example? It'll take for ever to enter all the dates ....

cheers

--
Kind regards
Mandy

"Ron Rosenfeld" wrote:
On Tue, 1 May 2007 09:19:02 -0700, mandy
wrote:

Does anyone know if I can take a date use the NETWORKDAYS function to count
forward a specified number of days

for example If I were to take 1st March and count forward 10 network days I
would get an answer of 14th March

If using NETWORKDAYS won't work does anyone know of anything else I can use?

Sorry, been playing with this for ages trying to see if this could work and
just can't seem to be able to do it!

Look at the WORKDAY function.
--ron

No, but here's a workaround:
=networkdays(A1,B1,C1:C100)

Put startdate in A1 enddate in B1, and list of days you want to ignore
in C1:C100.

To create a list of all wednesdays (for putting into C1:C100):
Start with a Wednesday in C1, using a calendar. e.g. 02/05/2007 (UK
date format).
In C2, use =C1+7.
Copy the formula down.

HTH

Andrew

using NETWORKDAYS
 

Here is a formula

=start_date+SIGN(num_days)*SMALL(IF((WEEKDAY(start _date+SIGN(num_days)*(ROW(INDIRECT("1:"&ABS(num_da ys)*10))))={2,3,5,6})*
ISNA(MATCH(start_date+SIGN(num_days)*(ROW(INDIRECT ("1:"&ABS(num_days)*10))),holidays,0)),ROW(INDIREC T("1:"&ABS(num_days)*10))),ABS(num_days))

which is an array formula, it should be committed with Ctrl-Shift-Enter, not
just Enter.
Excel will automatically enclose the formula in braces (curly brackets), do
not try to do this manually.
When editing the formula, it must again be array-entered.

--
---
HTH

Bob

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



"mandy" wrote in message
...
Superb - thanks for your help!
--
Kind regards
Mandy


"loudfish" wrote:

On May 1, 5:40 pm, mandy wrote:
Thank you so much - knew there had to be an answer out there. Don't
suppose
you know of any easy way of telling it to ignore every wednesday, for
example? It'll take for ever to enter all the dates ....

cheers

--
Kind regards
Mandy

"Ron Rosenfeld" wrote:
On Tue, 1 May 2007 09:19:02 -0700, mandy

wrote:

Does anyone know if I can take a date use the NETWORKDAYS function
to count
forward a specified number of days

for example If I were to take 1st March and count forward 10 network
days I
would get an answer of 14th March

If using NETWORKDAYS won't work does anyone know of anything else I
can use?

Sorry, been playing with this for ages trying to see if this could
work and
just can't seem to be able to do it!

Look at the WORKDAY function.
--ron

No, but here's a workaround:
=networkdays(A1,B1,C1:C100)

Put startdate in A1 enddate in B1, and list of days you want to ignore
in C1:C100.

To create a list of all wednesdays (for putting into C1:C100):
Start with a Wednesday in C1, using a calendar. e.g. 02/05/2007 (UK
date format).
In C2, use =C1+7.
Copy the formula down.

HTH

Andrew

using NETWORKDAYS
 

Hi Bob

Many thanks - will give it a go.
--
Kind regards
Mandy


"Bob Phillips" wrote:

Here is a formula

=start_date+SIGN(num_days)*SMALL(IF((WEEKDAY(start _date+SIGN(num_days)*(ROW(INDIRECT("1:"&ABS(num_da ys)*10))))={2,3,5,6})*
ISNA(MATCH(start_date+SIGN(num_days)*(ROW(INDIRECT ("1:"&ABS(num_days)*10))),holidays,0)),ROW(INDIREC T("1:"&ABS(num_days)*10))),ABS(num_days))

which is an array formula, it should be committed with Ctrl-Shift-Enter, not
just Enter.
Excel will automatically enclose the formula in braces (curly brackets), do
not try to do this manually.
When editing the formula, it must again be array-entered.

--
---
HTH

Bob

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



"mandy" wrote in message
...
Superb - thanks for your help!
--
Kind regards
Mandy


"loudfish" wrote:

On May 1, 5:40 pm, mandy wrote:
Thank you so much - knew there had to be an answer out there. Don't
suppose
you know of any easy way of telling it to ignore every wednesday, for
example? It'll take for ever to enter all the dates ....

cheers

--
Kind regards
Mandy

"Ron Rosenfeld" wrote:
On Tue, 1 May 2007 09:19:02 -0700, mandy

wrote:

Does anyone know if I can take a date use the NETWORKDAYS function
to count
forward a specified number of days

for example If I were to take 1st March and count forward 10 network
days I
would get an answer of 14th March

If using NETWORKDAYS won't work does anyone know of anything else I
can use?

Sorry, been playing with this for ages trying to see if this could
work and
just can't seem to be able to do it!

Look at the WORKDAY function.
--ron

No, but here's a workaround:
=networkdays(A1,B1,C1:C100)

Put startdate in A1 enddate in B1, and list of days you want to ignore
in C1:C100.

To create a list of all wednesdays (for putting into C1:C100):
Start with a Wednesday in C1, using a calendar. e.g. 02/05/2007 (UK
date format).
In C2, use =C1+7.
Copy the formula down.

HTH

Andrew