NETWORKDAYS
 

I currently have an Excel 2000 worksheet which tracks a project using
NETWORKDAYS to calculate the number of days taken between the start and end
date of the project.

However, I now need to have a column which shows a running total of
NETWORKDAYS taken so far (so there will be no end date) and when it reaches
15 days the number changes to red.

Can anyone help before I loose face.

Thank you for your assistance.
Suzanne

NETWORKDAYS
 

Conditional Formatting

Formula Is: =A1=15
Format as red


"Suzanne" wrote:

I currently have an Excel 2000 worksheet which tracks a project using
NETWORKDAYS to calculate the number of days taken between the start and end
date of the project.

However, I now need to have a column which shows a running total of
NETWORKDAYS taken so far (so there will be no end date) and when it reaches
15 days the number changes to red.

Can anyone help before I loose face.

Thank you for your assistance.
Suzanne

NETWORKDAYS
 

Hi thanks for the information but that only deals with part of the problem.
Unfortunately when there is no end date the number that appears in the
running total is a minus number.

So if I have a date in cell A1 No date in cell A2 Cell A3 = NETWORKDAYS
the answer shows as -27974?

--
Thank you for your assistance.
Suzanne


"Teethless mama" wrote:

Conditional Formatting

Formula Is: =A1=15
Format as red


"Suzanne" wrote:

I currently have an Excel 2000 worksheet which tracks a project using
NETWORKDAYS to calculate the number of days taken between the start and end
date of the project.

However, I now need to have a column which shows a running total of
NETWORKDAYS taken so far (so there will be no end date) and when it reaches
15 days the number changes to red.

Can anyone help before I loose face.

Thank you for your assistance.
Suzanne

NETWORKDAYS
 

What is your expectation of the result when there is no end date?


"Suzanne" wrote:

I currently have an Excel 2000 worksheet which tracks a project using
NETWORKDAYS to calculate the number of days taken between the start and end
date of the project.

However, I now need to have a column which shows a running total of
NETWORKDAYS taken so far (so there will be no end date) and when it reaches
15 days the number changes to red.

Can anyone help before I loose face.

Thank you for your assistance.
Suzanne

NETWORKDAYS
 

If you want to show the workdays so far when A2 is empty then try

=NETWORKDAYS(A1,IF(A2="",TODAY(),A2))

"Suzanne" wrote:

Hi thanks for the information but that only deals with part of the problem.
Unfortunately when there is no end date the number that appears in the
running total is a minus number.

So if I have a date in cell A1 No date in cell A2 Cell A3 = NETWORKDAYS
the answer shows as -27974?

--
Thank you for your assistance.
Suzanne


"Teethless mama" wrote:

Conditional Formatting

Formula Is: =A1=15
Format as red


"Suzanne" wrote:

I currently have an Excel 2000 worksheet which tracks a project using
NETWORKDAYS to calculate the number of days taken between the start and end
date of the project.

However, I now need to have a column which shows a running total of
NETWORKDAYS taken so far (so there will be no end date) and when it reaches
15 days the number changes to red.

Can anyone help before I loose face.

Thank you for your assistance.
Suzanne

NETWORKDAYS
 

Hi there, thanks for the response.

My expectation is to have a rolling total of working days taken so
far(excluding weekends), as the maximum turnaround time for the work is 15
days. This then acts a a warning that there may be a problem.
--
Thank you for your assistance.
Suzanne


"Teethless mama" wrote:

What is your expectation of the result when there is no end date?


"Suzanne" wrote:

I currently have an Excel 2000 worksheet which tracks a project using
NETWORKDAYS to calculate the number of days taken between the start and end
date of the project.

However, I now need to have a column which shows a running total of
NETWORKDAYS taken so far (so there will be no end date) and when it reaches
15 days the number changes to red.

Can anyone help before I loose face.

Thank you for your assistance.
Suzanne

NETWORKDAYS
 

Hi, thanks for the response will try your suggestion today and get back to you.
--
Thank you for your assistance.
Suzanne


"daddylonglegs" wrote:

If you want to show the workdays so far when A2 is empty then try

=NETWORKDAYS(A1,IF(A2="",TODAY(),A2))

"Suzanne" wrote:

Hi thanks for the information but that only deals with part of the problem.
Unfortunately when there is no end date the number that appears in the
running total is a minus number.

So if I have a date in cell A1 No date in cell A2 Cell A3 = NETWORKDAYS
the answer shows as -27974?

--
Thank you for your assistance.
Suzanne


"Teethless mama" wrote:

Conditional Formatting

Formula Is: =A1=15
Format as red


"Suzanne" wrote:

I currently have an Excel 2000 worksheet which tracks a project using
NETWORKDAYS to calculate the number of days taken between the start and end
date of the project.

However, I now need to have a column which shows a running total of
NETWORKDAYS taken so far (so there will be no end date) and when it reaches
15 days the number changes to red.

Can anyone help before I loose face.

Thank you for your assistance.
Suzanne

NETWORKDAYS
 

Hi there.

Thanks for the formula it works fine, but I am not sure why. Can you
provide me with any explanation?
--
Thank you for your assistance.
Suzanne


"daddylonglegs" wrote:

If you want to show the workdays so far when A2 is empty then try

=NETWORKDAYS(A1,IF(A2="",TODAY(),A2))

"Suzanne" wrote:

Hi thanks for the information but that only deals with part of the problem.
Unfortunately when there is no end date the number that appears in the
running total is a minus number.

So if I have a date in cell A1 No date in cell A2 Cell A3 = NETWORKDAYS
the answer shows as -27974?

--
Thank you for your assistance.
Suzanne


"Teethless mama" wrote:

Conditional Formatting

Formula Is: =A1=15
Format as red


"Suzanne" wrote:

I currently have an Excel 2000 worksheet which tracks a project using
NETWORKDAYS to calculate the number of days taken between the start and end
date of the project.

However, I now need to have a column which shows a running total of
NETWORKDAYS taken so far (so there will be no end date) and when it reaches
15 days the number changes to red.

Can anyone help before I loose face.

Thank you for your assistance.
Suzanne