+ Reply to Thread
Results 1 to 4 of 4

Generate future date based on past date and day

  1. #1
    Forum Contributor
    Join Date
    12-31-2008
    Location
    UK
    MS-Off Ver
    Excel 2007
    Posts
    149

    Generate future date based on past date and day

    Hi all,

    Please see attached.

    What I would like to do (via vba, as this is part of a bigger task) is autopopulate column D with the cloest date, matching the day in column C and using the date in column B, for the following year.

    So, using the attached as an example, the closest Thursday to 01/09/12 is 30/08/12.

    I'd be glad of any help with the code to autofill column D.

    Thanks in advance!
    Attached Files Attached Files

  2. #2
    Forum Guru
    Join Date
    11-29-2010
    Location
    Ukraine
    MS-Off Ver
    Excel 2019
    Posts
    4,168

    Re: Generate future date based on past date and day

    hi bd28, option, please check attachment
    Attached Files Attached Files

  3. #3
    Forum Expert
    Join Date
    07-20-2011
    Location
    Mysore, India.
    MS-Off Ver
    Excel 2019
    Posts
    7,081

    Re: Generate future date based on past date and day

    Pl see attached file with formula in D column.
    If it is OK mark the thread solved.
    Attached Files Attached Files

  4. #4
    Forum Contributor
    Join Date
    12-31-2008
    Location
    UK
    MS-Off Ver
    Excel 2007
    Posts
    149

    Re: Generate future date based on past date and day

    Sorry for the late response, I had subscriptions turned off!

    Both suggestions work great. Thank you for your time.

+ 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