+ Reply to Thread
Results 1 to 4 of 4

Convert list of dates in month / quarter / year format to months only

  1. #1
    Registered User
    Join Date
    08-09-2018
    Location
    USA
    MS-Off Ver
    365
    Posts
    2

    Convert list of dates in month / quarter / year format to months only

    Hello all,

    I have a list of dates in Column A.

    The first 3 years are month by month.
    The next 3 years are then quarter by quarter.
    From there on the dates are annual.

    I need to get this into a sheet which has column A as continuous monthly dates and then values for each month. If the date was a year in the source sheet, then the final sheet should simply have this value divided by 12.

    Excel sample 1.JPG

    Thanks for the help
    Attached Images Attached Images

  2. #2
    Administrator FDibbins's Avatar
    Join Date
    12-29-2011
    Location
    Duncansville, PA USA
    MS-Off Ver
    Excel 7/10/13/16/365 (PC ver 2310)
    Posts
    52,926

    Re: Convert list of dates in month / quarter / year format to months only

    Hi, welcome to the forum

    To best describe or illustrate your problem you would be better off attaching a dummy workbook. The workbook should contain the same structure and some dummy data of the same type as the type you have in your real workbook - so, if a cell contains numbers & letters in this format abc-123 then that should be reflected in the dummy workbook.

    To attach a file to your post,
    click advanced (next to quick post),
    scroll down until you see "manage file",
    click that and select "add files" (top right corner).
    click "select files" find your file, click "open" click "upload" click 'done" bottom right. click "submit reply"

    Once the upload is completed the file name will appear below the input boxes in this window.
    You can then close the window to return to the new post screen.
    1. Use code tags for VBA. [code] Your Code [/code] (or use the # button)
    2. If your question is resolved, mark it SOLVED using the thread tools
    3. Click on the star if you think someone helped you

    Regards
    Ford

  3. #3
    Registered User
    Join Date
    08-09-2018
    Location
    USA
    MS-Off Ver
    365
    Posts
    2

    Re: Convert list of dates in month / quarter / year format to months only

    Like this?
    Attached Files Attached Files

  4. #4
    Administrator FDibbins's Avatar
    Join Date
    12-29-2011
    Location
    Duncansville, PA USA
    MS-Off Ver
    Excel 7/10/13/16/365 (PC ver 2310)
    Posts
    52,926

    Re: Convert list of dates in month / quarter / year format to months only

    Just like that

+ Reply to Thread

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. Replies: 3
    Last Post: 10-04-2022, 07:27 AM
  2. [SOLVED] Convert year month to year quarter
    By yllew in forum Excel Formulas & Functions
    Replies: 8
    Last Post: 06-06-2018, 03:04 AM
  3. [SOLVED] How to prevent pivot table breaking down dates (Month, Quarter, Year, etc)
    By loccy in forum Excel Charting & Pivots
    Replies: 2
    Last Post: 09-28-2017, 01:44 AM
  4. [SOLVED] Convert Text Year and Month to Date Format
    By Barieq in forum Excel Formulas & Functions
    Replies: 4
    Last Post: 02-20-2017, 02:07 AM
  5. [SOLVED] VBA Insert Current Month, Year and subsequent months/year for 15 months
    By MichiganWilliams in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 12-19-2014, 03:49 PM
  6. [SOLVED] PIVOT TABLES: Grouping dates by Fiscal Year, Quarter and Month
    By bimmer5dude in forum Excel General
    Replies: 5
    Last Post: 06-30-2012, 09:13 PM
  7. Replies: 2
    Last Post: 06-21-2012, 08:17 PM

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