Calcualtion days in month from 2 dates
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
|