Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
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 |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
counting days | Excel Discussion (Misc queries) | |||
counting days? | Excel Discussion (Misc queries) | |||
Counting days | Excel Discussion (Misc queries) | |||
Counting days | Excel Worksheet Functions | |||
counting days | Excel Discussion (Misc queries) |