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
|