Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Counting Days Open
I need to count the number of days a line item is open workdays only. Right
now I can count the total number of days using this if statement; if(s2="",today()-A2,s2-a2), but when I try if(s2="",workday(today()-a2,holidays!a5:a17,workday(s2-a2,holidays!a5:a17) I get #NA error. What am I doing wrong. Thanks in advance, Roy |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
Counting Days Open
Try using the NETWORKDAYS function.
=IF(S2="","",NETWORKDAYS(A2,IF(S2="",TODAY(),S2),h olidays!A5:A17)) Biff "Roy" wrote in message ... I need to count the number of days a line item is open workdays only. Right now I can count the total number of days using this if statement; if(s2="",today()-A2,s2-a2), but when I try if(s2="",workday(today()-a2,holidays!a5:a17,workday(s2-a2,holidays!a5:a17) I get #NA error. What am I doing wrong. Thanks in advance, Roy |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
Counting Days Open
Ooops!
I goofed! I know that's hard to believe! <VVBG Try this instead: =NETWORKDAYS(A2,IF(S2="",TODAY(),S2),holidays!A5:A 17) Biff "T. Valko" wrote in message ... Try using the NETWORKDAYS function. =IF(S2="","",NETWORKDAYS(A2,IF(S2="",TODAY(),S2),h olidays!A5:A17)) Biff "Roy" wrote in message ... I need to count the number of days a line item is open workdays only. Right now I can count the total number of days using this if statement; if(s2="",today()-A2,s2-a2), but when I try if(s2="",workday(today()-a2,holidays!a5:a17,workday(s2-a2,holidays!a5:a17) I get #NA error. What am I doing wrong. Thanks in advance, Roy |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
counting days | Excel Discussion (Misc queries) | |||
counting days? | Excel Discussion (Misc queries) | |||
Counting days | Excel Discussion (Misc queries) | |||
Counting days | Excel Worksheet Functions | |||
counting days | Excel Discussion (Misc queries) |