Autopopulate Excel Calendar with Data Ranges

The way my calendars work (and I've done a lot of them on here) is they expect a single entry on the "Activities" sheet for a single date. In order to allow the User to put in date ranges, those have to be expanded to produce an event for every day within that range, which is what those blue formulae do in the helper columns. Though it may be possible to work directly from date ranges, this would mean that the formulae on the calendar sheet would need extensive revision.

I have made the necessary changes to your Activities sheet, and to the Calendar sheet in the attached file. You enter the details in columns A, B and C of the Activities sheet, and the rest is automatic. You can see where the formulae have been copied down to via the hyphens, and you should copy these further down if you have more data - I would copy them down a long way, and then those columns in blue can be hidden and forgotten about (Note that hyphens in column H also indicate how far the formulae in I to K have been copied - you should consider this as a contiguous block). You will notice, also, that if you have an event that only lasts one day, then you don't need to put the end-date into column C (though it doesn't matter if you do).

Anyway, hope this helps.

Pete

This is great! Thank you so much for sharing your excel skills with us.

You're welcome - glad to help.

Pete