Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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 |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
NETWORKDAYS | Excel Worksheet Functions | |||
networkdays | Excel Worksheet Functions | |||
Networkdays | Excel Worksheet Functions | |||
NETWORKDAYS | Excel Worksheet Functions | |||
Networkdays | Excel Worksheet Functions |