In an Excel calendar, how can I create a calendar event for a date based on an entry for another date?
- by James
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…