+ Reply to Thread
Results 1 to 2 of 2

Convert Monthly totals into daily average for each month...for a long time

  1. #1
    Registered User
    Join Date
    09-24-2008
    Location
    Edmond
    Posts
    3

    Convert Monthly totals into daily average for each month...for a long time

    Is there an easy way to convert monthly totals into daily averages for each month. I have 15 yeares worth of monthly data that I need to turn into daily numbers. So, below each day in March should say 57.5

    3/31/1991 1784
    4/30/1991 1656
    5/31/1991 1666
    6/30/1991 1462
    7/31/1991 1800
    8/31/1991 1270
    9/30/1991 1276
    10/31/1991 1650
    ....
    ....

  2. #2
    Forum Expert
    Join Date
    05-30-2012
    Location
    The Netherlands
    MS-Off Ver
    Office 365
    Posts
    14,987

    Re: Convert Monthly totals into daily average for each month...for a long time

    See the attached file.
    Notice my main language is not English.

    I appreciate it, if you reply on my solution.

    If you are satisfied with the solution, please mark the question solved.

    You can add reputation by clicking on the star * add reputation.

+ 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.6.0 RC 1