#1
|
|||
|
|||
NETWORKDAYS calculation for entire column
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? Or do I have to extend my paste to the next twenty or so rows to cover an expanded row count? |
|
Similar Threads | ||||
Thread | Thread Starter | Forum | Replies | Last Post |
Excel 2010 formula rounds - arithmetic average calculation | YooNaa Kim | Excel | 1 | 06-07-2011 08:50 PM |
Need to search a column for a macth and return a result from a third column | 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 |
Mail Merge Calculation Error | Lsbutler2000 | Mail Merge | 1 | 06-22-2007 06:33 AM |