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!