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

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

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