Hi James
Assuming you have the Analysis Toolpak loaded (ToolsAddinsAnalysis
Toolpak), then you can use the Eomonth() function.
With Start date in A1, End Date in B1
days in tarrif5 =EOMONTH(A1,0)-A1+1
days in tarrif6 =B1-EOMONTH(A1,0)

Format the cells containing the formula as General.
Both formulae assume that you are counting the whole of the start date
and the whole of the end date


--
Regards

Roger Govier


"jamesjohn"
wrote in message
...

Thanks very much !

It all seems so easy afterwards.

Now I have another one:

If I have different tarifs for different dates, how can I count how
many days are in each tarif for different start and end dates ?

Arrive 08/07 and Leave 13/08...how many days at tarif 5 and how many
days at tarif 6?


Start End Tarif
01/03/2006 13/04/2006 1
13/04/2006 17/04/2006 2
18/04/2006 16/06/2006 3
17/06/2006 07/07/2006 4
08/07/2006 04/08/2006 5
05/08/2006 25/08/2006 6
26/08/2006 08/09/2006 7
09/09/2006 28/10/2006 8

Driving me MAD !


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