I am creating a spread sheet to identify the number of days a patient was on
a particular ward. sometimes, the patient is a resident for a span of time
that includes several different months. What I need a formula that will break
down the number of days the patient was in admittance for each different
month:

Example:

John Doe 1/5/05 through 3/7/05
What is required is to calculate the number of days for each month,
separately.
Jan Feb Mar
? ? ?