+ Reply to Thread
Results 1 to 4 of 4

Populate Dates in Other Months Based on Jan Dates

  1. #1
    Registered User
    Join Date
    03-18-2010
    Location
    Layton, UT
    MS-Off Ver
    Excel 2013
    Posts
    73

    Smile Populate Dates in Other Months Based on Jan Dates

    I'm trying to create a budget workbook, but I need help populating the Due Date fields on all the other budgets. Manual input takes too much time.
    What I would like is a macro attached to the command button on Jan budget, that when clicked, it looks at January Due Dates (that I input) and use those due dates to create due dates for expense on all the other months (with the appropriate month). So a bill due January 11, on February would be due February 11, and so on.

    In case where an expense is due 1/31/15, the code for Feb (and other months with less than 31 day) would revert the date back to last day of Feb. If month only have 30 days, it revert back to 30th.

    I have attached a workbook with budgets laid out.

    Thanks
    catnap
    Attached Files Attached Files

  2. #2
    Registered User
    Join Date
    05-21-2015
    Location
    Brazil
    MS-Off Ver
    Office 2010
    Posts
    11

    Re: Populate Dates in Other Months Based on Jan Dates

    Pleas find if the results are enough.

    Paste on module and actie the buton:

    Please Login or Register  to view this content.

  3. #3
    Registered User
    Join Date
    03-18-2010
    Location
    Layton, UT
    MS-Off Ver
    Excel 2013
    Posts
    73

    Re: Populate Dates in Other Months Based on Jan Dates

    Thanks so much Victor. This worked perfect!!!

  4. #4
    Registered User
    Join Date
    03-18-2010
    Location
    Layton, UT
    MS-Off Ver
    Excel 2013
    Posts
    73

    Re: Populate Dates in Other Months Based on Jan Dates

    Copy of finished workbook
    Attached Files Attached Files

+ 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] Creating a formula to populate range of cells between dates based on start and end dates
    By Rainmain82 in forum Excel Formulas & Functions
    Replies: 6
    Last Post: 07-20-2014, 07:42 PM
  2. [SOLVED] Creating a formula to populate range of cells between dates based on start and end dates
    By Rainmain82 in forum Excel Formulas & Functions
    Replies: 6
    Last Post: 07-18-2014, 07:55 AM
  3. Replies: 8
    Last Post: 12-23-2013, 08:42 PM
  4. [SOLVED] Calculate expiry dates based on months
    By goldfield in forum Excel Formulas & Functions
    Replies: 2
    Last Post: 06-06-2013, 06:46 PM
  5. [SOLVED] Auto filling dates based on previously entered dates and averaging numbers if dates equal
    By grambograham in forum Excel Formulas & Functions
    Replies: 1
    Last Post: 10-11-2012, 03:21 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