Can Excel do this?

%3CLINGO-SUB%20id%3D%22lingo-sub-2257521%22%20slang%3D%22en-US%22%3ECan%20Excel%20do%20this%3F%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-2257521%22%20slang%3D%22en-US%22%3E%3CP%3EHello!%20I%20would%20like%20to%20be%20able%20to%20have%20date%20ranges%20automatically%20modify%2C%20based%20on%20one%20single%20date.%26nbsp%3B%20So%2C%20for%20example%2C%20I%20have%20an%20event%20that%20occurs%20on%20May%201st.%20There%20are%20numerous%20other%20events%20(within%20a%20date%20range)%20that%20must%20occur%20based%20on%20that%20date.%26nbsp%3B%20I%20want%20to%20see%20what%20the%20other%20dates%20would%20be%2C%20if%20I%20moved%20the%20May%201st%20date%2C%20and%20whether%20any%20of%20them%20are%20overlapping%20or%20not....I%20am%20not%20sure%20how%20to%20accomplish%20this%20or%20if%20it's%20possible.%26nbsp%3B%20Example%20of%20data%20below...%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EEvent%20A%20is%20held%20on%20May%201st%2C%202021.%3C%2FP%3E%3CP%3EEvent%20B%20is%20held%20at%20least%205%20days%2C%20but%20not%20more%20than%2010%20days%20after%20May%201st.%20For%20example%2C%20the%20new%20date%20range%20(Event%20B)%20would%20be%20May%206th%20-%20May%2011th.%20If%20I%20were%20to%20modify%20%22Event%20A%22%20to%20reflect%20October%201st.%26nbsp%3B%20I%20would%20want%20the%20date%20range%20(Event%20B)%20to%20automatically%20update%20the%20new%20date%20range%20to%20reflect%20October%206th%20-%20October%2011th.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EI%20have%20multiple%20%22Event%20B's%22%20to%20enter%2C%20based%20on%20Event%20A's%20date.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EHopefully%20it%20makes%20sense..%2C.does%20anyone%20know%20if%20this%20is%20even%20possible%20in%20Excel%3F%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-2257521%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EExcel%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3EFormulas%20and%20Functions%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E
Occasional Visitor

Hello! I would like to be able to have date ranges automatically modify, based on one single date.  So, for example, I have an event that occurs on May 1st. There are numerous other events (within a date range) that must occur based on that date.  I want to see what the other dates would be, if I moved the May 1st date, and whether any of them are overlapping or not....I am not sure how to accomplish this or if it's possible.  Example of data below...

 

Event A is held on May 1st, 2021.

Event B is held at least 5 days, but not more than 10 days after May 1st. For example, the new date range (Event B) would be May 6th - May 11th. If I were to modify "Event A" to reflect October 1st.  I would want the date range (Event B) to automatically update the new date range to reflect October 6th - October 11th.

 

I have multiple "Event B's" to enter, based on Event A's date.

 

Hopefully it makes sense..,.does anyone know if this is even possible in Excel?

 

1 Reply

@JEMED 

Is this what you want to happen?

Twifoo_0-1617764284912.png