difference of 2 dates
 

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




--
--------------------------------- --- -- -
Posted with NewsLeecher v3.9 Final
Web @ http://www.newsleecher.com/?usenet
------------------- ----- ---- -- -

difference of 2 dates
 

If you enter the formula in K2 and copy it down, Excel will adjust the
references automatically

--
Kind regards,

Niek Otten
Microsoft MVP - Excel

"sierrabunny" wrote in message
...
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




--
--------------------------------- --- -- -
Posted with NewsLeecher v3.9 Final
Web @ http://www.newsleecher.com/?usenet
------------------- ----- ---- -- -