[mso] Re: Number of Months Formula

You probably want to do a Google search for examples of use of the DateDif 
worksheet function (note the spelling - there is only one "f").  This has 
the ability to give you a result in months.

You can then use the MIN function to limit the number of months to 12.  I.e. 
=MIN(actualMonths,12)

Regards, Dave S

----- Original Message ----- 
From: "Kennedy, Melody" <mkennedy@xxxxxxxxxxxxxxxx>
To: <mso@xxxxxxxxxxxxx>
Sent: Friday, July 18, 2008 6:25 AM
Subject: [mso] Number of Months Formula


>I am trying to set up a formula to calculate annual costs for 2008 based
> on billed rate and number of months in year depending on the bill start
> date.  Example:
>
>
> Billed Rate         Billing Start Date            Annual Cost
>
> Jim       31.25                    3/12/2003                 =billed
> rate*12 (since prior to 1/1/2008)
>
> Joe       31.50                    4/1/2008                   =billed
> rate*9 (since after 1/1/2008)
>
>
>
> How do I set up a formula that knows the number of months left in the
> year if not a full year or knows it will be 12 months since starting
> billing prior to 1/1/2008?
>
>
>
> Please help, I have tried several formulas and it is not working.
>
>
>
> Melody
>
>
>
> This email and any documents accompanying this transmission may contain
> proprietary, privileged and/or confidential information and is intended
> solely for the addressee(s) named above.  If you are not the intended
> addressee/recipient, you are hereby notified that any use of,
> disclosure, copying, distribution, or reliance on the contents of this
> information is strictly prohibited and could result in legal action
> against you.  Please reply to the sender advising of the error in
> transmission and immediately delete/destroy the message and any
> accompanying documents.
>
>
>
>
> *************************************************************
> You are receiving this mail because you subscribed to mso@xxxxxxxxxxxxx or 
> MicrosoftOffice@xxxxxxxxxxxxxxxx
>
> To send mail to the group, simply address it to mso@xxxxxxxxxxxxx
>
> To Unsubscribe from this group, visit the group's homepage and use the 
> dropdown menu at the top.  This will allow you to unsubscribe your email 
> address or change your email settings to digest or vacation (no mail).
> http://www.freelists.org/webpage/mso
>
> To be able to share files with the group, you must join our Yahoo sister 
> group.  This group will not allow for posting of emails, but will allow 
> you to join and share problem files, templates, etc.: 
> http://tech.groups.yahoo.com/group/MicrosoftOffice . This group is for 
> FILE SHARING ONLY.
>
> If you are using Outlook and you see a lot of unnecessary code in your 
> email messages, read these instructions that explain why and how to fix 
> it:
> http://personal-computer-tutor.com/abc3/v28/greg28.htm
> ************************************************************* 

*************************************************************
You are receiving this mail because you subscribed to mso@xxxxxxxxxxxxx or 
MicrosoftOffice@xxxxxxxxxxxxxxxx

To send mail to the group, simply address it to mso@xxxxxxxxxxxxx

To Unsubscribe from this group, visit the group's homepage and use the dropdown 
menu at the top.  This will allow you to unsubscribe your email address or 
change your email settings to digest or vacation (no mail).
http://www.freelists.org/webpage/mso

To be able to share files with the group, you must join our Yahoo sister group. 
 This group will not allow for posting of emails, but will allow you to join 
and share problem files, templates, etc.:  
http://tech.groups.yahoo.com/group/MicrosoftOffice . This group is for FILE 
SHARING ONLY.

If you are using Outlook and you see a lot of unnecessary code in your email 
messages, read these instructions that explain why and how to fix it:
http://personal-computer-tutor.com/abc3/v28/greg28.htm
*************************************************************

Other related posts: