+ Reply to Thread
Results 1 to 4 of 4

Auto Populate Months from a specific cell

  1. #1
    Registered User
    Join Date
    01-09-2014
    Location
    Kentucky
    MS-Off Ver
    Excel 2007
    Posts
    9

    Auto Populate Months from a specific cell

    I have what may seem a small problem.

    I am currently building an Excel workbook that is for tracking attendance daily, weekly, monthly, and yearly.

    Each workbook is assigned to a specific person for a one year period. Ex. 12/1/2013 to 11/30/2014

    When the dates are entered a column automatically fills in the months of that year based on these dates. Ex. Dec-13, Jan-14, Feb-14, and so forth

    I was given a simple formula to create the column of dates which has worked in most cases. cell = value of previous cell containing a month+ 30. In other words, if A1 contains Dec-13 then A2 will automatically become Jan-14...etc...

    However, some months have fewer days or more days. Depending on the one year periods begin date it can autopopulate the same month twice.

    Example: 1/1/2014 begin date generates the following:

    Jan-14
    Jan-14
    Mar-14
    Apr-14
    May-14
    May-14
    Jun-14
    Jul-14
    Aug-14
    Sep-14
    Oct-14
    Nov-14
    Dec-14

    What can I use to auto populate the correct months instead of using the simple +30 above?

  2. #2
    Forum Expert Bob Phillips's Avatar
    Join Date
    09-03-2005
    Location
    Wessex
    MS-Off Ver
    Office 2003, 2010, 2013, 2016, 365
    Posts
    3,284

    Re: Auto Populate Months from a specific cell

    Assuming A1 has the initial date, try using

    =EOMONTH(A1,1)+1

  3. #3
    Forum Expert newdoverman's Avatar
    Join Date
    02-07-2013
    Location
    Port Dover, Ontario, Canada
    MS-Off Ver
    2010
    Posts
    10,330

    Re: Auto Populate Months from a specific cell

    You could use

    Formula: copy to clipboard
    Please Login or Register  to view this content.


    If A1 is the starting date, this will give the same date in successive months.
    <---------If you like someone's answer, click the star to the left of one of their posts to give them a reputation point for that answer.
    Ron W

  4. #4
    Registered User
    Join Date
    01-09-2014
    Location
    Kentucky
    MS-Off Ver
    Excel 2007
    Posts
    9

    Re: Auto Populate Months from a specific cell

    Thanks. The EDATE worked! Only if I used the begin date and changed the number of months to be added.

+ 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. [SOLVED] auto populate cell data based on specific selection in another cell
    By tinka590 in forum Excel Formulas & Functions
    Replies: 3
    Last Post: 05-07-2013, 02:37 AM
  2. MACRO needed to auto populate fields if an X is placed in a specific field
    By dbasch89 in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 10-31-2012, 04:03 PM
  3. Auto-populate specific data from one sheet to another
    By arskiracer in forum Excel General
    Replies: 0
    Last Post: 10-17-2012, 10:27 PM
  4. Auto-populate specific data from one sheet to another
    By fowlspace in forum Excel General
    Replies: 4
    Last Post: 10-17-2012, 09:19 PM
  5. extending macro to auto populate the specific cells
    By Avinash Kumar in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 08-11-2009, 07:43 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