Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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 ------------------- ----- ---- -- - |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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 ------------------- ----- ---- -- - |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Difference between dates | Excel Discussion (Misc queries) | |||
difference between two dates | Excel Discussion (Misc queries) | |||
difference between dates | Excel Discussion (Misc queries) | |||
difference between dates | Excel Discussion (Misc queries) | |||
difference between two dates | Excel Discussion (Misc queries) |