+ Reply to Thread
Results 1 to 2 of 2

Thread: Annualizing 6 mos. of data

  1. #1
    Registered User
    Join Date
    08-23-2011
    Location
    Boston, MA
    MS-Off Ver
    Excel 2003
    Posts
    1

    Annualizing 6 mos. of data

    I need help annualizing 6 months worth of data. The data for the first 6 mos. is as follows:

    1/31/2011: 0.9%
    2/28/2011: 0.0%
    3/31/2011: 0.9%
    4/30/2011: 2.8%
    5/31/2011: 0.9%
    6/30/2011: 4.7%

    I've seen formulas for annualizing 12 mo. data streams, but am unsure how to translate that for 6 mos. of data.

    Thanks for your help!

  2. #2
    Extremely Helpful member
    Join Date
    12-23-2006
    Location
    Belgium
    MS-Off Ver
    XL2003
    Posts
    6,127

    Re: Annualizing 6 mos. of data

    Hi and welcome to the board

    You have posted in the Outlook forum. is this correct?
    Quoting entire posts clutters the forum and makes threads hard to read !

    If you are pleased with a member's answer then use the Star icon to rate it

    Click here to see forum rules

+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.2.0