Hello,
I am trying to determine a formula that will calculate the the number of days that fall within a certain month.
Example: April
[TABLE="width: 435"]
<tbody>[TR]
[TD="align: left"]04/24/2010[/TD]
[TD]04/02/2011[/TD]
[TD]2[/TD]
[/TR]
[TR]
[TD="align: left"]03/02/2011[/TD]
[TD]04/03/2011[/TD]
[TD]3[/TD]
[/TR]
</tbody><colgroup><col><col><col></colgroup>[/TABLE]
I need to do this for the months of April to July so I can calculate a proration based on the days falling in a specific month.
Please assist
I am trying to determine a formula that will calculate the the number of days that fall within a certain month.
Example: April
[TABLE="width: 435"]
<tbody>[TR]
[TD="align: left"]04/24/2010[/TD]
[TD]04/02/2011[/TD]
[TD]2[/TD]
[/TR]
[TR]
[TD="align: left"]03/02/2011[/TD]
[TD]04/03/2011[/TD]
[TD]3[/TD]
[/TR]
</tbody><colgroup><col><col><col></colgroup>[/TABLE]
I need to do this for the months of April to July so I can calculate a proration based on the days falling in a specific month.
Please assist
