Partial Year Adjustments (Mod Function)
 

I have a fiscal year with a year end on Oct 31st. I have a tariff that is
expressed in $/month. Say its $6000/month. I want to use a start date input
with the tariff to adjuste the annual fiscal amount. Say I have a term of 2
years. My Starte Date for the tariff is 1-Dec-2007. So in year one I have
335 days (31-Oct-2008 minus 1-Dec-2007) or 335/30.5 or 10.98 months. In year
2 I should have 12 months and in the last year I should have only 1 month as
per the table below. As such I can multiple my tariff as $6000*11/12,
$6000*12/12, $6000*1/12,

How do I set up the "# month" calc below to show the number of months in
each year such that it shows the partial months in the first year and the
partial months in the last year? I know I have to incorporate the MOD
function.

Year 1 2
3
Date 31-Oct-2008 31-Oct-2009
31-Oct-2010
# Days 335 700
1065
# months 11 12
1

Partial Year Adjustments (Mod Function)
 

I think you can use the DATEDIF function for what you want.

=DATEDIF(A1,B1,"m")

where A1 has your state date and B1 has the end date... the function will
return the total number of months between the two dates.

Rick


"ExcelMonkey" wrote in message
...
I have a fiscal year with a year end on Oct 31st. I have a tariff that is
expressed in $/month. Say its $6000/month. I want to use a start date
input
with the tariff to adjuste the annual fiscal amount. Say I have a term of
2
years. My Starte Date for the tariff is 1-Dec-2007. So in year one I
have
335 days (31-Oct-2008 minus 1-Dec-2007) or 335/30.5 or 10.98 months. In
year
2 I should have 12 months and in the last year I should have only 1 month
as
per the table below. As such I can multiple my tariff as $6000*11/12,
$6000*12/12, $6000*1/12,

How do I set up the "# month" calc below to show the number of months in
each year such that it shows the partial months in the first year and the
partial months in the last year? I know I have to incorporate the MOD
function.

Year 1 2
3
Date 31-Oct-2008 31-Oct-2009
31-Oct-2010
# Days 335 700
1065
# months 11 12
1