Partial Year Adjustments (Mod Function)

E

ExcelMonkey

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
 
R

Rick Rothstein \(MVP - VB\)

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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads


Top