0

Sounds a bit confusing, doesn't it?

I've created an 'events calendar' in Excel for my local area. Each date throughout the year is assigned to a row.

What I want to do is, when I enter an event for a particular date, then automatically create an entry elsewhere in the calendar for an action to be taken.

So for example, There's an event on the 30th July, so I enter it into the calendar. I'd like to be able to specify that an entry should be made 4 weeks earlier, on the 2nd July, to tell me to blog, tweet or whatever about that particular event.

Can Excel help me to do that and if so, what do I need to do?

Improve this question
2
  • A VB script will do that. In the long term, you need to improve your system. Excel isn't designed for such use.
    – dnbrv
    Mar 22, 2012 at 17:48
  • this is possible in excel (using an offset type formula. That the reminder feature on a mail/calendar program would probably be infinitely better suited to your use case. yahoo mail has a calendar feature that should do what you want
    – Pynner
    Mar 23, 2012 at 3:30

1 Answer 1

Reset to default
1

If the dates are in ColumnA starting in Row1 and all your events are in Column C (but in Row29 or above) then you would get a warning of which event 28 days beforehand if you insert =INDEX(A:C,ROW()+28,3) into B1 and double click bottom RH corner.

Improve this answer

You must log in to answer this question.

Not the answer you're looking for? Browse other questions tagged .