Counting Days Open

  • Thread starter Thread starter Guest
  • Start date Start date
G

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
 
Try using the NETWORKDAYS function.

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

Biff
 
Ooops!

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

Try this instead:

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

Biff
 
Back
Top