![]() |
#1
|
|||
|
|||
![]()
Hello and greetings etc.
Am sure you can do this but can't find anything on the web. On my spreadsheet column D contains dates and column E contains date I want to calculate the difference in days between column E and column D. This works fine =NETWORKDAYS(E2,D2) Now if I paste this through the existing rows the calculation is working for each row. So far so good. However an issue with rise if an additional line is added to the spreadsheet ![]() Is there a way to substitue a variable, for want of a better term, so the calculation isn't row specific, ie a new row and the formula will automatically calculate the difference? ![]() |
|
![]() |
||||
Thread | Thread Starter | Forum | Replies | Last Post |
![]() |
YooNaa Kim | Excel | 1 | 06-07-2011 08:50 PM |
![]() |
pdfaust | Excel | 2 | 02-03-2011 03:02 PM |
Formula not getting copied to entire column | theacegary | Excel | 1 | 11-29-2010 02:18 PM |
how to make fields calculation variable according to the filter i use | duraid | Project | 0 | 09-09-2010 01:05 PM |
![]() |
Lsbutler2000 | Mail Merge | 1 | 06-22-2007 06:33 AM |