Roger,

I haven't made myself clear, because you have sent me the same formula
as for finding how many days in each month.

The table in my post is the start and end dates of the tarifs.

You will see that some tarifs only last a couple of weeks and are in
the same month and other tarifs take in dates from 3 different months.

I need to calculate how many days of each month are in each different
tarif.

Hope this makes sense !


--
jamesjohn
------------------------------------------------------------------------
jamesjohn's Profile: http://www.excelforum.com/member.php...fo&userid=9692
View this thread: http://www.excelforum.com/showthread...hreadid=545300