tesouthworthjr,

Try
In A1 your start date.
In B1 blank unless the end date is within that month when it will be the
end date.
In C1 IF (B1"",B1,EOMONTH(A1,0)).
in D1 C1-A1 and format the cell as number with 0 decimal places.

Henry

"tesouthworthjr" wrote in message
...
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
? ? ?