+ Reply to Thread
Results 1 to 4 of 4

Formula to show monthly intervals from any given month

  1. #1
    Valued Forum Contributor
    Join Date
    02-07-2013
    Location
    Philippines
    MS-Off Ver
    Excel 2007, 2010
    Posts
    541

    Formula to show monthly intervals from any given month

    Hi Experts,

    If I type in 04/2016 in A13 - I need a formula in A12 (drag up) that would show 03/2016, 02/2016, 01/2016, 12/2015 and so on until i reach 04/2015 in A1.

    I know i can subtract 30 but it folds up and i was hoping to end at the first day of every month for =INDEX purposes.

    Please help
    If I've helped U pls click on d *Add Reputation

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

    Re: Formula to show monthly intervals from any given month

    A1 = 01-04-2015
    a2 = 01-05-2015

    select both cells and drag it below as far as needed.

    it will automatic expand to 01-06-2015 / 01-07-2015 and so on.
    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.

  3. #3
    Administrator FDibbins's Avatar
    Join Date
    12-29-2011
    Location
    Duncansville, PA USA
    MS-Off Ver
    Excel 2000/3/7/10/13/16/365
    Posts
    52,318

    Re: Formula to show monthly intervals from any given month

    04/2016 is not a date in excel, it is just text.

    A date is just a number representing the number of days passed since 1/1/900...and then formated in a way that we recognise as a date. So, for instance, today (Mon May 2016) is actually 42506

    If you are working with dates, it is almost always better yo use real dates (including the day, month and year), then you can use them more easily in calcs.

    You can format dates to look like (almost) whatever you want, by using the built-in formatting options, or by using Custom Formatting
    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

  4. #4
    Forum Guru AlKey's Avatar
    Join Date
    07-20-2009
    Location
    Lakeland, FL USA
    MS-Off Ver
    Microsoft Office 2010/ Office 365
    Posts
    8,903

    Re: Formula to show monthly intervals from any given month

    1. Enter a real date into cell A13
    2. Enter formula in A1 and copy down to cell A12
    Formula: copy to clipboard
    Please Login or Register  to view this content.

    format cells as Custom, m/dddd
    v A
    1 4/2015
    2 5/2015
    3 6/2015
    4 7/2015
    5 8/2015
    6 9/2015
    7 10/2015
    8 11/2015
    9 12/2015
    10 1/2016
    11 2/2016
    12 3/2016
    13 4/2016
    If you like my answer please click on * Add Reputation
    Don't forget to mark threads as "Solved" if your problem has been resolved

    "Nothing is so firmly believed as what we least know."
    --Michel de Montaigne

+ 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: 0
    Last Post: 10-27-2015, 10:59 AM
  2. [SOLVED] Need Formula that will show 'Month" for date that fall in the particular month
    By JESSHOR60 in forum Excel Formulas & Functions
    Replies: 4
    Last Post: 12-28-2014, 01:47 PM
  3. Month over Month formula to show increase or decrease in rankings for SEO
    By lindsbay in forum Excel Formulas & Functions
    Replies: 1
    Last Post: 02-12-2014, 03:03 AM
  4. [SOLVED] calculate pay checks per month, to get monthly income value for that month.
    By tladd in forum Excel Formulas & Functions
    Replies: 5
    Last Post: 11-20-2012, 09:51 PM
  5. Replies: 2
    Last Post: 06-13-2012, 06:55 AM
  6. A formula to show Next month
    By Stan Brown in forum Excel Formulas & Functions
    Replies: 16
    Last Post: 09-06-2005, 07:05 AM
  7. A formula to show Next month
    By AndreL in forum Excel Formulas & Functions
    Replies: 4
    Last Post: 06-11-2005, 12:05 AM

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