Is this simply the highest date less the lowest? If so, then

=NETWORKDAYS(MIN(A1:A1000),MAX(A1:A1000))

NETWORKDAYS is part of the analysis toolpak add-in, so that must be
installed.

--
HTH

Bob Phillips

"Barbara" wrote in message
...
Hi Bob, thaks for your reply. I' ll be more specific giving you part of my
sheet.

05-01-2004 Vigaria
05-01-2004 Vigaria
06-01-2004 Vigaria
06-01-2004 Vigaria
06-01-2004 Vigaria
06-01-2004 Vigaria
07-01-2004 Vigaria
07-01-2004 Vigaria
08-01-2004 Vigaria
08-01-2004 Vigaria
08-01-2004 Vigaria
08-01-2004 Vigaria
09-01-2004 Cabouca
09-01-2004 Vigaria
09-01-2004 Vigaria
12-01-2004 Cabouca

Here, we have 6 days of production. Hope that you can help me.




"Bob Phillips" wrote:

Hi Barbara,

A bit more detail please.

Does a cell in that column contain many dates or just 1?

If the former, give an example of how you would manually calculate the
production days with say 3 dates in the cell, and how the dates are
differentiated.

If the latter, what signifies a start date and what an end date?

Do start and end dates get included?

--
HTH

Bob Phillips

"Barbara" wrote in message
...
Hi,

I have a sheet with a column "Day" where the production date is
introduced
for each mouvement (5-1-04; 6-1-04, 6,2,04...) along the year (those
days
can
be repeated according to the production).
I need to calculate how many days of production there is by month and
by
year.
Can somebody help me????
Tks.
Barbara