....what can I say. Genius!!

Thank you so much!!




"vezerid" wrote:

Roger,

Thank you, I am flattered <s.
Yes, you are right, I had created an extra column because for a while I
had a discrepancy in the total number of days (forgot the +1). The OP
should paste your formula.

Regards,
Kostis


Roger Govier wrote:
Hi Kostis

Very nice solution!
There might be a typo though as I think the formula in D2 needs to start
with dates from Year D1 not E1

=$C2/($B2-$A2+1)*
SUMPRODUCT((ROW(INDIRECT($A2&":"&$B2))=DATE(D$1,8 ,1))*
(ROW(INDIRECT($A2&":"&$B2))<DATE(D$1+1,8,1)))

--
Regards

Roger Govier