Working days between first and last column with data

[longip]

Hello and Merry Christams !


This is my first post here and I try to find some help to a problem that I can't solved it.


Basically, I keep truck of my projects in excel file (please download here - I did not know how to attach a file).
Each day, data is entered manually in C5:AJ11, according to different operations. Week-end are marked in red. In column B, I count the total number of worked days.


Where do I need help ?
In B10, I would like to count the total WORKINGDAYs between first column with data (04-dec-2012) and last column with data (19-dec-2012).
If last column with data were 31-dec-2012, I would have needed to count working days between 04-dec-2012 and 19-dec-2012.
Is there any way to do this ?


Kind regards.

 

[norulen]

Try this formula
=NETWORKDAYS(A1,B1)

 

[longip]

Try this formula
=NETWORKDAYS(A1,B1)

No jokes needed. I come here to find help, not jokes.

 

[norulen]

Excuse me!! i dint get you? Does this formula not work for you?

 

[norulen]

NETWORKDAYS - Excel - Office.com

 

[longip]

NETWORKDAYS will do the trick for the working days.

But, I will need to determine the first column with data and the last column with data.