+ Reply to Thread
Results 1 to 3 of 3

Fill Column with dates between two limits

  1. #1
    Registered User
    Join Date
    10-14-2010
    Location
    BC Canada
    MS-Off Ver
    Excel 2007
    Posts
    68

    Thumbs up Fill Column with dates between two limits

    Hi,

    Not sure where to start.

    I've got dates formatted like:
    8/31/2018 (As text)

    I'd like to pick out the oldest and newest date in a column
    Then fill in a second column starting with the oldest and ending with the newest

    If someone could point me in the right direction that would be great. My VB is poor on a good day.

    For example:

    Input Output
    9/6/2018 8/31/2018
    9/2/2018 9/1/2018
    8/31/2018 9/2/2018
    9/3/2018
    9/4/2018
    9/5/2018
    9/6/2018

  2. #2
    Forum Moderator alansidman's Avatar
    Join Date
    02-02-2010
    Location
    Steamboat Springs
    MS-Off Ver
    MS Office 365
    Posts
    20,432

    Re: Fill Column with dates between two limits

    Please Login or Register  to view this content.

  3. #3
    Forum Guru Pete_UK's Avatar
    Join Date
    12-31-2011
    Location
    Warrington, England
    MS-Off Ver
    Office 2019 (still learning)
    Posts
    21,684

    Re: Fill Column with dates between two limits

    Or, using formulae:

    Put this formula in B2:

    =MIN(A2:A4)

    and this in B3:

    =IF($B$2+ROWS($1:1)<=MAX($A$2:$A$4),$B$2+ROWS($1:1),"")

    Format those two cells as a date in the style you prefer, then copy B3 down as far as you need to (you'll get blanks if you copy too far).

    Hope this helps.

    Pete

+ 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: 8
    Last Post: 07-04-2018, 10:03 AM
  2. compare dates in two columns, fill second column if date is later than first
    By kittycrickett in forum Excel Formulas & Functions
    Replies: 3
    Last Post: 11-11-2015, 02:24 PM
  3. [SOLVED] limits of what you can and cannot fill a listfillrange with for ActiveX-Control Listbox
    By cmore in forum Excel Programming / VBA / Macros
    Replies: 7
    Last Post: 09-22-2013, 10:49 AM
  4. Fill column with double week day dates
    By JMGC in forum Excel Formulas & Functions
    Replies: 0
    Last Post: 01-31-2013, 12:09 PM
  5. Macro to Auto Fill Dates in Column
    By erock24 in forum Excel Programming / VBA / Macros
    Replies: 9
    Last Post: 01-26-2009, 12:02 PM
  6. Search column for Dates and Colour Fill
    By Sinn in forum Excel General
    Replies: 1
    Last Post: 10-05-2007, 12:51 PM
  7. [SOLVED] How do I Fill a column with dates (for 3 years of daily data)
    By Apple_pi in forum Excel General
    Replies: 1
    Last Post: 02-18-2006, 04:55 PM

Tags for this Thread

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