Hi,

I have been looking at all the posts about dates on here but cannot find a solution to my problem.

I have 2 coulmns startdate and enddate I want to break down the months and number of days for these months between the two dates

eg Startdate = 01/04/2013 enddate = 04/11/2013 I want to be able to output something like this

Apr May June July August September October November
30 31 30 31 31 30 31 4

My aim is to show the frequency of days for each month, I caannot do it in a Pivot as the Pivot will place 217 in April (unless someone knows a different way of presenting this in a Pivot)

Thanks in anticipation

Claire