Counting Days Open

[Guest]

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

 

[T. Valko]

Try using the NETWORKDAYS function.

=IF(S2="","",NETWORKDAYS(A2,IF(S2="",TODAY(),S2),holidays!A5:A17))

Biff

 

[T. Valko]

Ooops!

I goofed! I know that's hard to believe! <VVBG>

Try this instead:

=NETWORKDAYS(A2,IF(S2="",TODAY(),S2),holidays!A5:A17)

Biff