ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Worksheet Functions (https://www.excelbanter.com/excel-worksheet-functions/)
-   -   @IF Formula (https://www.excelbanter.com/excel-worksheet-functions/234787-%40if-formula.html)

Ann 'Formula challenged'

@IF Formula
 
Hello, I struggle incorporating @IF formulas.

I have three date columns. I need to find the work days between any two
dates.

My challenge is when I use the following formula for the following dates:

K5 reflects 01/09/2009 and J5 reflects 01/09/2009 and I5 reflects 01/02/2009

I use the formula =NETWORKDAYS(J5,K5) the value comes to 1 and it should be
zero.

I use the formula =NETWORKDAYS(I5,K5) the value comes to 6 and should be 5

Also another challenge I can't figure out:

K6 reflects 01/12/2009 and J5 reflects 01/13/2009
I use the formula =NETWORKDAYS(I5,K5) the value comes to (2) and should be
(1).

Thank you in advance for your help!!









Bernard Liengme[_3_]

@IF Formula
 
The range of dates 01/12/2009 and 01/13/2009 contains two work days when one
counts inclusively
If you want an exclusive count use =NETWORKDAYS(I5,K5) -1
best wishes
--
Bernard V Liengme
Microsoft Excel MVP
http://people.stfx.ca/bliengme
remove caps from email


"Ann 'Formula challenged'" <Ann 'Formula challenged'
@discussions.microsoft.com wrote in message
...
Hello, I struggle incorporating @IF formulas.

I have three date columns. I need to find the work days between any two
dates.

My challenge is when I use the following formula for the following dates:

K5 reflects 01/09/2009 and J5 reflects 01/09/2009 and I5 reflects
01/02/2009

I use the formula =NETWORKDAYS(J5,K5) the value comes to 1 and it should
be
zero.

I use the formula =NETWORKDAYS(I5,K5) the value comes to 6 and should be 5

Also another challenge I can't figure out:

K6 reflects 01/12/2009 and J5 reflects 01/13/2009
I use the formula =NETWORKDAYS(I5,K5) the value comes to (2) and should be
(1).

Thank you in advance for your help!!










Ann ''Formula challenged''

@IF Formula
 
Hi,

I actually need an @IF function incorporated as it doesn't work when it is a
negative number such as my example. Would you be able to incorproate an @IF
into my NETWORDDAYS formula? I can't seem to get the right brackets or signs
to get it to be valid. So it should be something like if K5=orJK than +1,
if K5=or<1, than -1

"Bernard Liengme" wrote:

The range of dates 01/12/2009 and 01/13/2009 contains two work days when one
counts inclusively
If you want an exclusive count use =NETWORKDAYS(I5,K5) -1
best wishes
--
Bernard V Liengme
Microsoft Excel MVP
http://people.stfx.ca/bliengme
remove caps from email


"Ann 'Formula challenged'" <Ann 'Formula challenged'
@discussions.microsoft.com wrote in message
...
Hello, I struggle incorporating @IF formulas.

I have three date columns. I need to find the work days between any two
dates.

My challenge is when I use the following formula for the following dates:

K5 reflects 01/09/2009 and J5 reflects 01/09/2009 and I5 reflects
01/02/2009

I use the formula =NETWORKDAYS(J5,K5) the value comes to 1 and it should
be
zero.

I use the formula =NETWORKDAYS(I5,K5) the value comes to 6 and should be 5

Also another challenge I can't figure out:

K6 reflects 01/12/2009 and J5 reflects 01/13/2009
I use the formula =NETWORKDAYS(I5,K5) the value comes to (2) and should be
(1).

Thank you in advance for your help!!











Bernard Liengme[_3_]

@IF Formula
 
=ABS(NETWORKDAYS(I5,K5))
will always give a positive value

=IF(K5=I5,NETWORKDAYS(I5,K5),"")
will give answer when K5 ==I5 but will return blank otherwise

best wishes
--
Bernard V Liengme
Microsoft Excel MVP
http://people.stfx.ca/bliengme
remove caps from email


"Ann ''Formula challenged''"
wrote in message
...
Hi,

I actually need an @IF function incorporated as it doesn't work when it is
a
negative number such as my example. Would you be able to incorproate an
@IF
into my NETWORDDAYS formula? I can't seem to get the right brackets or
signs
to get it to be valid. So it should be something like if K5=orJK than
+1,
if K5=or<1, than -1

"Bernard Liengme" wrote:

The range of dates 01/12/2009 and 01/13/2009 contains two work days when
one
counts inclusively
If you want an exclusive count use =NETWORKDAYS(I5,K5) -1
best wishes
--
Bernard V Liengme
Microsoft Excel MVP
http://people.stfx.ca/bliengme
remove caps from email


"Ann 'Formula challenged'" <Ann 'Formula challenged'
@discussions.microsoft.com wrote in message
...
Hello, I struggle incorporating @IF formulas.

I have three date columns. I need to find the work days between any
two
dates.

My challenge is when I use the following formula for the following
dates:

K5 reflects 01/09/2009 and J5 reflects 01/09/2009 and I5 reflects
01/02/2009

I use the formula =NETWORKDAYS(J5,K5) the value comes to 1 and it
should
be
zero.

I use the formula =NETWORKDAYS(I5,K5) the value comes to 6 and should
be 5

Also another challenge I can't figure out:

K6 reflects 01/12/2009 and J5 reflects 01/13/2009
I use the formula =NETWORKDAYS(I5,K5) the value comes to (2) and should
be
(1).

Thank you in advance for your help!!













All times are GMT +1. The time now is 01:21 PM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com