Formula to display Count of Days in given month, using list of Startand End Dates

[Dave K]

I have a large number of rows that contain a start date and end date.
I am attempting to generate a count of days within that date range
that are in a particular month, for example, Jan of 2011.

Any suggestions for a formula that could be used to display the
amounts shown in Column C would be helpful.

Layout is:

A B C
Start Date End Date Count of Days in Jan2011
1/10/11 4/7/11 21
2/6/11 3/1/11 0
12/20/10 2/15/11 31
Etc.

 

[DCG-jaeson]

Dave,

I think the best way is to create a table from Start Date to End Date
then use the Formula below each cell in the table =text(cell,"m") then
count all 1

Cheerz!
~jaeson