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
|