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
|