How to manage dates on an auto refreshing demo site

No sorry I still don't understand the problem.

It doesn't matter whether the dates are spread over 2-3 months or if they are in different columns.

Let's take an example, you have meticulously hand coded your demo system to work with today's date.

Ok let's say you have an office reminder set for 15th December 2015 on your demo site.

But let's say it is now 18th of December 2015 and a demo user is accessing your site.

So all you do is take today's date which is 18th December 2015 and simply minus 15th of December.

This equals three days. Therefore your adjust formula is simple. simply increase ALL your dates and reminders in the database by 3 days. Couldn't be simpler. If you want I can write a simple script showing this.

Practical guide to IgnitedCMS - Book coming soon, www.ignitedcms.com