I am not sure how is the easiest way to accomplish this task, and I am hoping
for some insight/ideas on a formula that will do the job for me. I have 2
date columns: 1)start date and 2)end date, both formatted with month day
year. This date range may span several months.

For each line item, I need to count the number of open occurrences per
month. I do this manually, by creating the resulting columns I need (shown
below). I am hoping there is a formula that can do this count (or data
evaluation) for me.

Example of Orig File:

Item Start Date End Date
#1 May 05, 2008 Jul 28, 2008
#2 May 29, 2008 Aug 3, 2008
#3 Jun 03, 2008 Sep 20, 2008

Example of desired result (additional columns) based on analysis of the
start and end dates above:

May Jun Jul Aug Sep
Item Count Count Count Count Count
#1 1 1 1 0 0
#2 1 1 1 1 0
#3 0 1 1 1 1

Best regards,
Luce