NETWORKDAYS Troubleshoot
 

NETWORKDAYS should yield a higher count of days as time goes by, but it does
not for some reason.

'Any thoughts?

DOUG

NETWORKDAYS Troubleshoot
 

It gives you the number of working days between the dates so it increases if
the second date increases but may not if the next date is an holiday.

Share the formula you are entering and how you are testing it.

"DOUG ECKERT" wrote:

NETWORKDAYS should yield a higher count of days as time goes by, but it does
not for some reason.

'Any thoughts?

DOUG

NETWORKDAYS Troubleshoot
 

=NETWORKDAYS(S2,A2). However, I believe the problem was the date format in
the second column (mm-yyy) conflicted with the date format in the first
column (dd-mmm-yyy). It seems to work now.

Thanks, Sheeloo.

DOUG

"Sheeloo" wrote:

It gives you the number of working days between the dates so it increases if
the second date increases but may not if the next date is an holiday.

Share the formula you are entering and how you are testing it.

"DOUG ECKERT" wrote:

NETWORKDAYS should yield a higher count of days as time goes by, but it does
not for some reason.

'Any thoughts?

DOUG

NETWORKDAYS Troubleshoot
 

Date format has nothing to do with it, as all functions, including
Networkdays, ignore the format. Formatting is just for appearance. All
functions use the underlying value.

Regards,
Fred.

"DOUG ECKERT" wrote in message
...
=NETWORKDAYS(S2,A2). However, I believe the problem was the date format
in
the second column (mm-yyy) conflicted with the date format in the first
column (dd-mmm-yyy). It seems to work now.

Thanks, Sheeloo.

DOUG

"Sheeloo" wrote:

It gives you the number of working days between the dates so it increases
if
the second date increases but may not if the next date is an holiday.

Share the formula you are entering and how you are testing it.

"DOUG ECKERT" wrote:

NETWORKDAYS should yield a higher count of days as time goes by, but it
does
not for some reason.

'Any thoughts?

DOUG

NETWORKDAYS Troubleshoot
 

Well, the underlying value in the second column did not include a day in the
date. When I added the day to the date, it worked.

Thank you.

DOUG

"Fred Smith" wrote:

Date format has nothing to do with it, as all functions, including
Networkdays, ignore the format. Formatting is just for appearance. All
functions use the underlying value.

Regards,
Fred.

"DOUG ECKERT" wrote in message
...
=NETWORKDAYS(S2,A2). However, I believe the problem was the date format
in
the second column (mm-yyy) conflicted with the date format in the first
column (dd-mmm-yyy). It seems to work now.

Thanks, Sheeloo.

DOUG

"Sheeloo" wrote:

It gives you the number of working days between the dates so it increases
if
the second date increases but may not if the next date is an holiday.

Share the formula you are entering and how you are testing it.

"DOUG ECKERT" wrote:

NETWORKDAYS should yield a higher count of days as time goes by, but it
does
not for some reason.

'Any thoughts?

DOUG

NETWORKDAYS Troubleshoot
 

That's because you had text in the cell originally, and changed it to a
number. Formatting had nothing to do with it.

Regards,
Fred.

"DOUG ECKERT" wrote in message
...
Well, the underlying value in the second column did not include a day in
the
date. When I added the day to the date, it worked.

Thank you.

DOUG

"Fred Smith" wrote:

Date format has nothing to do with it, as all functions, including
Networkdays, ignore the format. Formatting is just for appearance. All
functions use the underlying value.

Regards,
Fred.

"DOUG ECKERT" wrote in message
...
=NETWORKDAYS(S2,A2). However, I believe the problem was the date
format
in
the second column (mm-yyy) conflicted with the date format in the first
column (dd-mmm-yyy). It seems to work now.

Thanks, Sheeloo.

DOUG

"Sheeloo" wrote:

It gives you the number of working days between the dates so it
increases
if
the second date increases but may not if the next date is an holiday.

Share the formula you are entering and how you are testing it.

"DOUG ECKERT" wrote:

NETWORKDAYS should yield a higher count of days as time goes by, but
it
does
not for some reason.

'Any thoughts?

DOUG

NETWORKDAYS Troubleshoot
 

What formula are you using?
What date values are in the cells to which the formula refers?
What value did you get from the formula?
What value did you expect?
Have you ensured that Tools/ Options/ Calculation is set to Automatic, not
Manual?
--
David Biddulph

"DOUG ECKERT" wrote in message
...
NETWORKDAYS should yield a higher count of days as time goes by, but it
does
not for some reason.

'Any thoughts?

DOUG

NETWORKDAYS Troubleshoot
 

Yes. Thank you.

"Fred Smith" wrote:

That's because you had text in the cell originally, and changed it to a
number. Formatting had nothing to do with it.

Regards,
Fred.

"DOUG ECKERT" wrote in message
...
Well, the underlying value in the second column did not include a day in
the
date. When I added the day to the date, it worked.

Thank you.

DOUG

"Fred Smith" wrote:

Date format has nothing to do with it, as all functions, including
Networkdays, ignore the format. Formatting is just for appearance. All
functions use the underlying value.

Regards,
Fred.

"DOUG ECKERT" wrote in message
...
=NETWORKDAYS(S2,A2). However, I believe the problem was the date
format
in
the second column (mm-yyy) conflicted with the date format in the first
column (dd-mmm-yyy). It seems to work now.

Thanks, Sheeloo.

DOUG

"Sheeloo" wrote:

It gives you the number of working days between the dates so it
increases
if
the second date increases but may not if the next date is an holiday.

Share the formula you are entering and how you are testing it.

"DOUG ECKERT" wrote:

NETWORKDAYS should yield a higher count of days as time goes by, but
it
does
not for some reason.

'Any thoughts?

DOUG

NETWORKDAYS Troubleshoot
 

David: The cell contained text. I added a date (or day figure) to the text,
thus converting it to a date and it worked.

Thank you.

DOUG

"David Biddulph" wrote:

What formula are you using?
What date values are in the cells to which the formula refers?
What value did you get from the formula?
What value did you expect?
Have you ensured that Tools/ Options/ Calculation is set to Automatic, not
Manual?
--
David Biddulph

"DOUG ECKERT" wrote in message
...
NETWORKDAYS should yield a higher count of days as time goes by, but it
does
not for some reason.

'Any thoughts?

DOUG