+ Reply to Thread
Results 1 to 3 of 3

Populate a calendar from a table

  1. #1
    Registered User
    Join Date
    05-27-2016
    Location
    Kalamazoo, MI
    MS-Off Ver
    2013
    Posts
    2

    Populate a calendar from a table

    This is probably a ridiculously easy question but I'm lost in the weeds a bit.

    I have a table with dates that I need to populate in a calendar. The table starts with an end date (closing date) and then the other dates are triggered by the end date (ex. application is needed 45 days before close). I need to then get those dates applied to a calendar. I built a calendar that I think will work, but the last step of tying it all together is escaping me.

    I'd love to know a. if this is the right kind of calendar for this set up, and b. how to I tie the calculator tab to the calendar tab.

    Thanks!
    Attached Files Attached Files
    Last edited by jfk1400ny; 05-27-2016 at 02:12 PM.

  2. #2
    Forum Expert
    Join Date
    05-20-2015
    Location
    Chicago, Illinois
    MS-Off Ver
    2016
    Posts
    2,103

    Re: Populate a calendar from a table

    I don't think your choice in calendar is ideal. If you're trying to implant relevant text into the actual calendar, having each calendar date equate to exactly one cell makes populating the cell with both the formula for the date and the formula for the text (if any) awkward, at best. I would advise sifting through Excel's templates for something that fits better. There are calendars specifically designed for this kind of thing that I couldn't track down, but even a basic family calendar can be combined with your "Calculator" page and some INDEX/MATCH formulas to do the trick. I threw together a quick sample to show what I mean. I input the necessary formulas into the sheet for 'May' so you can see how it looks. You can copy that setup into the other months. Again, though, it'd probably be worth your time to peruse the free templates that already exist. Easier options exist out there.

    (I had to delete every month except Jan and May to get the file size down to a level that I could upload, but the entire calendar is available as a template)
    Attached Files Attached Files

  3. #3
    Registered User
    Join Date
    05-27-2016
    Location
    Kalamazoo, MI
    MS-Off Ver
    2013
    Posts
    2

    Re: Populate a calendar from a table

    Thank you so much for this great advice and the calendar example. After I uploaded my question I started sifting through all the templates in Excel and found a timeline option where I could still add the formulas to calculate the other dates. I like the option you sent as well and I may just replicate it as you mentioned.

    Thank you again for your help!


+ 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 Calendar from Table Excel
    By Corocotan in forum Excel General
    Replies: 15
    Last Post: 12-10-2020, 02:13 AM
  2. [SOLVED] Populate a calendar from a table
    By Gerard.GRC in forum Excel Formulas & Functions
    Replies: 20
    Last Post: 07-05-2015, 11:53 PM
  3. Populate an Excel calendar template with events from a separate table
    By Dana_Carter in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 10-12-2014, 12:14 PM
  4. Populate monthly calendar with table
    By Marco-Kun in forum Excel Programming / VBA / Macros
    Replies: 16
    Last Post: 08-08-2014, 04:18 AM
  5. Replies: 2
    Last Post: 04-01-2014, 09:24 PM
  6. Auto Populate Calendar From Data Table
    By tommy_b in forum Excel General
    Replies: 2
    Last Post: 10-28-2013, 06:04 PM
  7. Replies: 0
    Last Post: 04-25-2011, 04:28 PM

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