using IF to skip

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

Tyro
Fri Mar 14 16:47:01 CDT 2008

=IF(NETWORKDAYS(B23,B29)-1=-1,0,NETWORKDAYS(B23,B29)-1)
=IF(NETWORKDAYS(B23,B29)-1=-1,"",NETWORKDAYS(B23,B29)-1)

The first formula returns 0 for the -1 and the second formula returns the
empty string

Tyro

"Julie" <Julie@discussions.microsoft.com> wrote in message
news:2C04BDDE-0153-4C70-8CDD-3170398BB283@microsoft.com...
>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

Rick
Fri Mar 14 16:53:06 CDT 2008

This formula will let the calculation take place only if both B23 and B29
have entries in them...

=IF(OR(B23="",B29=""),"",NETWORKDAYS(B23,B29)-1)

Rick


"Julie" <Julie@discussions.microsoft.com> wrote in message
news:2C04BDDE-0153-4C70-8CDD-3170398BB283@microsoft.com...
>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

Rick
Fri Mar 14 17:00:32 CDT 2008

And if you want the calculation to take place as long as both are not blank
(which is really what your original question asked)...

=IF(AND(B23="",B29=""),"",NETWORKDAYS(B23,B29)-1)

although I would wonder at the usefulness of an answer if one of the cells
were blank (hence my original answer).

Rick


"Rick Rothstein (MVP - VB)" <rick.newsNO.SPAM@NO.SPAMverizon.net> wrote in
message news:ue8a%232hhIHA.5280@TK2MSFTNGP02.phx.gbl...
> This formula will let the calculation take place only if both B23 and B29
> have entries in them...
>
> =IF(OR(B23="",B29=""),"",NETWORKDAYS(B23,B29)-1)
>
> Rick
>
>
> "Julie" <Julie@discussions.microsoft.com> wrote in message
> news:2C04BDDE-0153-4C70-8CDD-3170398BB283@microsoft.com...
>>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
>

Julie
Fri Mar 14 17:21:01 CDT 2008

thank you so much

"Rick Rothstein (MVP - VB)" wrote:

> This formula will let the calculation take place only if both B23 and B29
> have entries in them...
>
> =IF(OR(B23="",B29=""),"",NETWORKDAYS(B23,B29)-1)
>
> Rick
>
>
> "Julie" <Julie@discussions.microsoft.com> wrote in message
> news:2C04BDDE-0153-4C70-8CDD-3170398BB283@microsoft.com...
> >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
>
>