calculate number of days
 

i need to calculate the # of working days between 2 columns (I and J).
i'm using formula =NETWORKDAYS(I2,J2). Is there any way to use a variable
somehow so I don't have to manually change the formula for each line in
column K?..........?


ex:
=NETWORKDAYS(I2,J2)..........=NETWORKDAYS(I3,J3).. ......=NETWORKDAYS(I4,J4)

tia............charlene

calculate number of days
 

Enter the formula to a cell and drag it down...OR even copy paste the cell
(not the formula)
--
If this post helps click Yes
---------------
Jacob Skaria


"Charlene Lee" wrote:

i need to calculate the # of working days between 2 columns (I and J).
i'm using formula =NETWORKDAYS(I2,J2). Is there any way to use a variable
somehow so I don't have to manually change the formula for each line in
column K?..........?


ex:
=NETWORKDAYS(I2,J2)..........=NETWORKDAYS(I3,J3).. ......=NETWORKDAYS(I4,J4)

tia............charlene

calculate number of days
 

Enter the formula below in K2
=NETWORKDAYS(I2,J2)
Copy K1
Selct K3:K100 (change 100 to your last row)
Press CTRL-V (i.e. paste the copied formula)

"Charlene Lee" wrote:

i need to calculate the # of working days between 2 columns (I and J).
i'm using formula =NETWORKDAYS(I2,J2). Is there any way to use a variable
somehow so I don't have to manually change the formula for each line in
column K?..........?


ex:
=NETWORKDAYS(I2,J2)..........=NETWORKDAYS(I3,J3).. ......=NETWORKDAYS(I4,J4)

tia............charlene

calculate number of days
 

The below link would be useful in understanding more about relative and
absolute reference..

http://www.cpearson.com/excel/relative.aspx

If this post helps click Yes
---------------
Jacob Skaria


"Jacob Skaria" wrote:

Enter the formula to a cell and drag it down...OR even copy paste the cell
(not the formula)
--
If this post helps click Yes
---------------
Jacob Skaria


"Charlene Lee" wrote:

i need to calculate the # of working days between 2 columns (I and J).
i'm using formula =NETWORKDAYS(I2,J2). Is there any way to use a variable
somehow so I don't have to manually change the formula for each line in
column K?..........?


ex:
=NETWORKDAYS(I2,J2)..........=NETWORKDAYS(I3,J3).. ......=NETWORKDAYS(I4,J4)

tia............charlene

calculate number of days
 

"Charlene Lee" wrote:

i need to calculate the # of working days between 2 columns (I and J).
i'm using formula =NETWORKDAYS(I2,J2). Is there any way to use a variable
somehow so I don't have to manually change the formula for each line in
column K?..........?


ex:
=NETWORKDAYS(I2,J2)..........=NETWORKDAYS(I3,J3).. ......=NETWORKDAYS(I4,J4)

tia............charlene

but i dont want to have to change each line variable...j3...j4...j5 to increade it by 1

calculate number of days
 

Try
=NETWORKDAYS(I2,$J$2)

and copy down

If this post helps click Yes
---------------
Jacob Skaria


"Charlene Lee" wrote:


"Charlene Lee" wrote:

i need to calculate the # of working days between 2 columns (I and J).
i'm using formula =NETWORKDAYS(I2,J2). Is there any way to use a variable
somehow so I don't have to manually change the formula for each line in
column K?..........?


ex:
=NETWORKDAYS(I2,J2)..........=NETWORKDAYS(I3,J3).. ......=NETWORKDAYS(I4,J4)

tia............charlene

but i dont want to have to change each line variable...j3...j4...j5 to increade it by 1