#1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
external usenet poster
 
Posts: 152
Default 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
  #2   Report Post  
Posted to microsoft.public.excel.worksheet.functions
external usenet poster
 
Posts: 3,718
Default 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

  #3   Report Post  
Posted to microsoft.public.excel.worksheet.functions
external usenet poster
 
Posts: 152
Default 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

  #4   Report Post  
Posted to microsoft.public.excel.worksheet.functions
external usenet poster
 
Posts: 3,718
Default 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

  #5   Report Post  
Posted to microsoft.public.excel.worksheet.functions
external usenet poster
 
Posts: 287
Default 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



  #6   Report Post  
Posted to microsoft.public.excel.worksheet.functions
external usenet poster
 
Posts: 152
Default 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

  #7   Report Post  
Posted to microsoft.public.excel.worksheet.functions
external usenet poster
 
Posts: 152
Default 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

  #8   Report Post  
Posted to microsoft.public.excel.worksheet.functions
external usenet poster
 
Posts: 152
Default 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

Reply
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
NETWORKDAYS Trouvera52 Excel Worksheet Functions 2 October 14th 06 12:21 AM
networkdays rsenn Excel Worksheet Functions 0 November 24th 05 01:42 AM
Networkdays DKerr Excel Worksheet Functions 1 September 28th 05 03:30 PM
NETWORKDAYS sinbad Excel Worksheet Functions 2 July 19th 05 12:32 PM
Networkdays Susan Hayes Excel Worksheet Functions 1 April 5th 05 06:33 PM


All times are GMT +1. The time now is 08:54 PM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"