I have a list of cell addresses to be looked-up by their ids in column
A and B:
1,F1
2,M31

I am trying to get the number of days between two dates minus 1 to exclude
the start date.
Here is the formula i have with M2:M15 being my holidays.
=NETWORKDAYS(F1, G1, $M$2:$M$15)-1

I vaguely remember there was a formula to show the path and filename on a
cell in a worksheet but for the life of me I cannot remember it - can anyone
help???
Many thanks

In my spreadsheet I have an input table. I want to count the number of trucks
leaving each city on a certain day. Then in addition, ideally for one city I
want to know how many loads are heavier that 15MT. The other cities don't
have heavy loads.

I would like to count how many lorries leave each city with <15t and a
separate column >15t for each date.
Date          City          Weight
11-Feb    Omsk    25

Sorry about the cross post but I'm getting desperate...
row 1 contains headers. col A and C contain values. I need to populate Col B
with values like the following
B2 needs to read R2C3

I have full address in once cell and I was just wondering if there an
way to un-concatenate it in all different cells. Here is the example
Cell A1
16545 Dingo St

In Excel 2003 I used to click Insert>Names>Define
and i could view and manage the full Name list.
How can I do it in Excel 2007 ?
Thanks.

The formula in cell C32 id =COUNTIF(C14:G14,"P"). This is just the
attendance count for one week. Now in the next column I want next week's
attendance count and when I drag it, the reference moves just one cell
ahead...it becomes =COUNTIF(D14:H14,"P"). I want the refrence to move ...

How to copy from Excel 2003 spreadsheet to MS Outlook html email as pure
text and not as Excel object?
There isn't Paste special available and often mail recipients who don't have
Excel installed don't see this "object" correctly.

I have a worksheet that has data in cells which has also been color coded.  
What I would like to do is find a way to search for, say, all of the yellow
cells in the worksheets and sum the numbers in those cells.  And then, of
course, do the same for all of the other colors in the ...

Hi all, how would I write this in cell G14
=E14-E13 if F14 cell has a number otherwise be blank
        E        F          G
13   100      50         50

Sheet 1 has an X column that has dates.  It also has column BD that has a
"Yes" or "No" entered in it.  The cell range is from 2-221.  On sheet 2, I
want to count the number of "no" entries in BD for only the records where the
date in X is greater than 1/1/2006.

Hi all, how would I write this in cell G14
=E14-E13 if F14 cell has a number otherwise be blank
        E        F          G
13   100      50         50

I have several columns of data.  Column A is names, column B is hours, column
C is dates.  
I'm looking for a formula that returns the date when the sum of hours for a
person (from a list in the range G2:G8)  reaches a certain point (the number