+ Reply to Thread
Results 1 to 2 of 2

Combined Months of a year into a year

  1. #1
    Registered User
    Join Date
    06-08-2007
    Location
    Cardington, Ohio
    MS-Off Ver
    2010
    Posts
    11

    Combined Months of a year into a year

    Situation:

    I have a worksheet that tracks Propane usage. On one of the columns is the date, I have the '05 and '06 heating seasons, the dates range from 9-2005 to 3-2006 for the '05 season and 9-2006 to 3-2007 for the '06 season.

    Goal:

    Combine the 9/2005 through 3/2006 dates to read 2005 in a separate column
    Combine the 9/2006 through 3/2007 dates to read 2006 in a separate column

    Question:

    What is the easiest way to perform this function?
    Last edited by Djchaney3; 06-12-2007 at 09:14 AM.
    "If you want to know what a man's like take a good look at how he treats his inferiors not his equals"

  2. #2
    Forum Contributor WinteE's Avatar
    Join Date
    04-07-2007
    Location
    Netherlands
    Posts
    544
    See attached file.

    Erik
    Attached Files Attached Files
    Just keep it simple !


    http://www.excelguide.eu
    In English as well as in Dutch

+ 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