I don't have anything on my site for this function as yet but depending on how urgent it is I could write something up by the end of the week if you wanted to know how to do this yourself.
If urgent though I've just created it quickly in Excel for you. Download the sample attached and I've explained how I did it below.
If you change the date in cell D2 which is the first date then the rest of the worksheet will update. I've used 2 different types of formulas due to the layout but essentially cells E2 to G2 are just using a =D2+1 formula which just takes the first date entered and adds 1 day. All of row 2 uses this method. Then for cell A3 I've used a formula of =G2+1 which is the same but I'm following on from the end of row 2. From row 4 onwards I've just used =A3+7 which is taking the date from the cell above and adding 7 days.
So long story short if you change the date in cell D2 the rest will update.
You can now insert this into a PPT slide if you wish or use it stand alone. Use the Fill Color options in Excel to color code any of the important dates.
|