Matching numbers witin a series
 

A3 and A4 contain from and to dates.

B1 and B2 contain Year one start & Finish (eg 1/1/05 and 31/12/05)
Subsequent Colums contain subsequent years.

I need help in trying to establish how many days within the dates specified
in A3 and A4 are also contained within the periods specified in each column.

I am using Microsoft Office XP.
--
Ron.

Matching numbers witin a series
 

Hi!

If I understand correctly:

=SUMPRODUCT(--(ROW(INDIRECT(B1&":"&B2))=$A3),--(ROW(INDIRECT(B1&":"&B2))<=$A4))

Copy across as needed.

Biff

"Bismark" wrote in message
...
A3 and A4 contain from and to dates.

B1 and B2 contain Year one start & Finish (eg 1/1/05 and 31/12/05)
Subsequent Colums contain subsequent years.

I need help in trying to establish how many days within the dates
specified
in A3 and A4 are also contained within the periods specified in each
column.

I am using Microsoft Office XP.
--
Ron.

Matching numbers witin a series
 

Thanks Biff.

Your response was exactly what I needed.

I don't understand it, but it does exactly what I want.

Many thanks.
--
Ron.


"Bismark" wrote:

A3 and A4 contain from and to dates.

B1 and B2 contain Year one start & Finish (eg 1/1/05 and 31/12/05)
Subsequent Colums contain subsequent years.

I need help in trying to establish how many days within the dates specified
in A3 and A4 are also contained within the periods specified in each column.

I am using Microsoft Office XP.
--
Ron.

Matching numbers witin a series
 

You're welcome. Thanks for the feedback!

Biff

"Bismark" wrote in message
...
Thanks Biff.

Your response was exactly what I needed.

I don't understand it, but it does exactly what I want.

Many thanks.
--
Ron.


"Bismark" wrote:

A3 and A4 contain from and to dates.

B1 and B2 contain Year one start & Finish (eg 1/1/05 and 31/12/05)
Subsequent Colums contain subsequent years.

I need help in trying to establish how many days within the dates
specified
in A3 and A4 are also contained within the periods specified in each
column.

I am using Microsoft Office XP.
--
Ron.

Matching numbers witin a series
 

=MIN($B$2,$A$4)-MAX($B$1,$A$3)+1

Regards,
Bernd