Home

Generating a Calendar of events synchronized to one key event

%3CLINGO-SUB%20id%3D%22lingo-sub-458034%22%20slang%3D%22en-US%22%3EGenerating%20a%20Calendar%20of%20events%20synchronized%20to%20one%20key%20event%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-458034%22%20slang%3D%22en-US%22%3E%3CP%3EHi%2C%3C%2FP%3E%3CP%3EI'm%20trying%20to%20figure%20out%20if%20there%20is%20a%20existing%20template%2C%20macro%2C%20etc.%20that%20I%20case%20use%20to%20do%20the%20following%20(in%20Excel%20or%20otherwise)%3A%3C%2FP%3E%3CP%3EI%20want%20to%20be%20able%20to%20create%20a%20series%20of%20events%20that%20have%20a%20relative%20dating%20to%20one%20main%20event%20and%20then%20generate%20a%20calendar%20of%20all%20of%20the%20events.%20For%20example%2C%20Events%20A%20and%20B%20occur%203%20weeks%20prior%20to%20Event%20X%20and%20Event%20C%20occurs%208%20days%20prior%20to%20Event%20X%20-%20I%20want%20to%20be%20able%20to%20input%20this%20information%20and%20then%20generate%20a%20calendar%20for%20any%20year%20that%20places%20the%20events%20in%20the%20proper%20date%20based%20upon%20their%20relative%20dating.%20I'm%20not%20sure%20if%20this%20is%20easy%20to%20do%20in%20Excel%20or%20what%20search%20terms%20to%20use%20to%20describe%20what%20I%20am%20looking%20for.%3C%2FP%3E%3CP%3EThanks!%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-458034%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EExcel%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3EFormulas%20and%20Functions%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3EMacros%20and%20VBA%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E
mgoldstone
Occasional Visitor

Hi,

I'm trying to figure out if there is a existing template, macro, etc. that I case use to do the following (in Excel or otherwise):

I want to be able to create a series of events that have a relative dating to one main event and then generate a calendar of all of the events. For example, Events A and B occur 3 weeks prior to Event X and Event C occurs 8 days prior to Event X - I want to be able to input this information and then generate a calendar for any year that places the events in the proper date based upon their relative dating. I'm not sure if this is easy to do in Excel or what search terms to use to describe what I am looking for.

Thanks!

Related Conversations
Tabs and Dark Mode
cjc2112 in Discussions on
46 Replies
flashing a white screen while open new tab
Deleted in Discussions on
14 Replies
How to Prevent Teams from Auto-Launch
chenrylee in Microsoft Teams on
29 Replies
Stable version of Edge insider browser
HotCakeX in Discussions on
35 Replies