software

A3 and A4 contain from and to dates.

B1 and B2 contain Year one start amp; 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.

Hi!

If I understand correctly:

=SUMPRODUCT(--(ROW(INDIRECT(B1amp;quot;:quot;amp;B2))gt;=$A3),--(ROW(INDIRECT(B1amp;quot;:quot;amp;B2))lt;=$A4))

Copy across as needed.

Biff

quot;Bismarkquot; gt; wrote in message
...
gt; A3 and A4 contain from and to dates.
gt;
gt; B1 and B2 contain Year one start amp; Finish (eg 1/1/05 and 31/12/05)
gt; Subsequent Colums contain subsequent years.
gt;
gt; I need help in trying to establish how many days within the dates
gt; specified
gt; in A3 and A4 are also contained within the periods specified in each
gt; column.
gt;
gt; I am using Microsoft Office XP.
gt; --
gt; Ron.
Thanks Biff.

Your response was exactly what I needed.

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

Many thanks.
--
Ron.quot;Bismarkquot; wrote:

gt; A3 and A4 contain from and to dates.
gt;
gt; B1 and B2 contain Year one start amp; Finish (eg 1/1/05 and 31/12/05)
gt; Subsequent Colums contain subsequent years.
gt;
gt; I need help in trying to establish how many days within the dates specified
gt; in A3 and A4 are also contained within the periods specified in each column.
gt;
gt; I am using Microsoft Office XP.
gt; --
gt; Ron.

You're welcome. Thanks for the feedback!

Biff

quot;Bismarkquot; gt; wrote in message
...
gt; Thanks Biff.
gt;
gt; Your response was exactly what I needed.
gt;
gt; I don't understand it, but it does exactly what I want.
gt;
gt; Many thanks.
gt; --
gt; Ron.
gt;
gt;
gt; quot;Bismarkquot; wrote:
gt;
gt;gt; A3 and A4 contain from and to dates.
gt;gt;
gt;gt; B1 and B2 contain Year one start amp; Finish (eg 1/1/05 and 31/12/05)
gt;gt; Subsequent Colums contain subsequent years.
gt;gt;
gt;gt; I need help in trying to establish how many days within the dates
gt;gt; specified
gt;gt; in A3 and A4 are also contained within the periods specified in each
gt;gt; column.
gt;gt;
gt;gt; I am using Microsoft Office XP.
gt;gt; --
gt;gt; Ron.
=MIN($B$2,$A$4)-MAX($B$1,$A$3) 1

Regards,
Bernd