You are right! I didn't think of that. Would it be easier to do by days? For example the "block" were I input for 6 months, we can say if it's between 150 and 180 days display "name" of event here or else display nothing. Then for 5 months we can do if between 120 days and 180 days...... So on and so forth. I could figure out for the most part how to adjust the dates. Just can't think of how to have it search for dates in all of sheet 1, then calculate dates so EVENT DATE - TODAYS DATE = XXX DAYS, therefore input "NAME" here.
Jun 8, 2016 at 05:36 PM
Jun 8, 2016 at 06:56 PM