Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
![]()
I am using =NETWORKDAYS(B23,B29)-1 as one of my formulas. I have the -1
because I am tracking several different time frames going from one place to another and without the -1 it is counting a day twice. I need this formula in every cell that has the days, but there won't be a time span every time. When there's no time span i get a -1 in the cell which is messing up count. Is there a way to add an IF function to the function above that says If -1 then skip? or count as 0? I've tried several different ways and it's not working. Thanks |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
skip to worksheet | Excel Worksheet Functions | |||
Can I skip all these questions? | Excel Discussion (Misc queries) | |||
If false skip to next | Excel Worksheet Functions | |||
Skip Over Blanks | Excel Discussion (Misc queries) | |||
Skip a day of the week | Excel Discussion (Misc queries) |