[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
*************************************************************

Other related posts: