+ Reply to Thread
Results 1 to 5 of 5

Auto Populated Calendar

  1. #1
    Registered User
    Join Date
    06-24-2019
    Location
    South Carolina
    MS-Off Ver
    2016
    Posts
    2

    Auto Populated Calendar

    Hello,

    I'm looking for ways to make a calendar that auto populates events in Excel from month to month. Calendar items will rely on other calendar items to populate. For example, event X will be on the 15th of the month and event Y will be 2 business days after this. I have no use for transferring it over to Outlook, as I print and distribute.

    Any suggestions? Everything that I find online seems to refer to creating simple employee calendars or standard calendars with no events.

  2. #2
    Valued Forum Contributor
    Join Date
    02-10-2019
    Location
    Georgia, USA
    MS-Off Ver
    Office 365
    Posts
    948

    Re: Auto Populated Calendar

    I'm not clear on what you're asking. Do you have a sample spreadsheet that shows what you're looking for, with expected results?

  3. #3
    Registered User
    Join Date
    06-24-2019
    Location
    South Carolina
    MS-Off Ver
    2016
    Posts
    2

    Re: Auto Populated Calendar

    I've attached a very basic sample. In this, Events A and B occur daily. Event D happens 2 business days after Event C. The current method really isn't a method at all; simply copy and pasting from one month to another based on the rules. Some of the rules are: 2 BD after the 15th, 4 BD after Event C, 12th or next business day.
    Attached Files Attached Files

  4. #4
    Valued Forum Contributor
    Join Date
    02-10-2019
    Location
    Georgia, USA
    MS-Off Ver
    Office 365
    Posts
    948

    Re: Auto Populated Calendar

    Sounds like you may need to create a list of events and build rules using functions like workday, using Index/Match and Aggregate formulas. It could get very complicated depending on what rules you establish. There are calendars out there that do this already which I would think about instead of recreating the wheel. There are very smart people on this forum though so one of them may be able to come with something nifty.

  5. #5
    Valued Forum Contributor
    Join Date
    02-10-2019
    Location
    Georgia, USA
    MS-Off Ver
    Office 365
    Posts
    948

    Re: Auto Populated Calendar

    BTW, here's a link to a discussion about excel calendars, and explaining the formulas for dates in detail. It won't give you exactly what you are looking for, but it may be helpful:
    https://www.myonlinetraininghub.com/...ulas-explained

+ 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. Auto Populated Calendar
    By erice in forum Excel General
    Replies: 1
    Last Post: 03-19-2018, 10:03 PM
  2. Replies: 0
    Last Post: 08-27-2015, 11:37 PM
  3. Replies: 3
    Last Post: 06-05-2015, 01:09 PM
  4. Replies: 0
    Last Post: 07-14-2014, 10:32 AM
  5. Replies: 4
    Last Post: 05-27-2013, 10:01 AM
  6. [SOLVED] Help with Formula to capture dates to be populated on a calendar
    By Inez15 in forum Excel Formulas & Functions
    Replies: 1
    Last Post: 03-08-2013, 06:27 AM
  7. Calendar VBA auto filling week and month based on calendar entry.
    By perrymagic in forum Excel Programming / VBA / Macros
    Replies: 7
    Last Post: 12-18-2011, 02:00 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