Guys,

I wonder if i can impose on you just a little bit more. I wont have an end
date in all cases until the case is closed. In these instances i would like
to do the calculation on todays date versus the start date and then if the
end date is added then against the end date. I have tried to include
Vezerid's calculation in a nested if but without much sucess. Any ideas????

rgds Paul

"Teethless mama" wrote:

Total for March =DAY(EOMONTH(A1,0))-DAY(A1)
Total for April =DAY(EOMONTH(A1,1))
Total for May =DAY(EOMONTH(A2,0))-DAY(A2)

You need an Analysis ToolPak under Tools Add-Ins


"phocused" wrote:

I have a start date and an end date, what I would like to do is to use these
2 dates to calculate the number of days per month. So for example
Start Date: 23/03/06
End Date: 19/05/06
What I want to do is to work out how many days this is in March, April, May
respectively.

So I will end up with a column total for march of 8days, april 30days,
may19days.

any help would be gratefully accepted