difference of 2 dates

S

sierrabunny

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
 
N

Niek Otten

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

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

calculate number of days 5
Subtracting Dates to Find the Difference in Hours 6
Calculating number of workdays between 2 dates 15
CALCULATE BETWEEN TWO DATES EXCLUDING WEEKENDS 3
@IF Formula 3
how to find text vaues for a given grade? 0
days calculations 7
Difference between Date & Time for workdays 0

Top