Year Planner Mod needed plz

**Sgt.Trojan** · 08-13-2009, 02:50 PM

wow. Things move quickly!

**oldchippy** · 08-13-2009, 05:51 PM

Hi,

Sorry it took a time, but all you need to do is enter the start date in cell F45 and everything else will recalculate.

Do you want row 2 to start at number 1 or the month number?

**Sgt.Trojan** · 08-14-2009, 03:26 AM

Double post sorry

**Sgt.Trojan** · 08-14-2009, 03:39 AM

Thank you for the reply oldchippy. That does do what I need but in a different way

Re: Row 2 - I'm not fussed about what's in Row 2.

I've tried changing the info in cell B1 to reflect the academic year and it sends the values into spasm

(ie when I change the "2009" to "2009-2010"). B1 still has a bearing on the calcs. I am trying to make it idiot proof so I can use it and pass it onto my colleagues so altering the info B1 year by year is the ideal solution. Even if B1 will only display the academic start year I can just add a text box to state the year displayed is the "Academic start year."

Is there a solution?

Best Regards

EDIT: The September column only goes upto 28 days which has a knock on effect to the subsequent dates meaning they are incorrect.
DOH! And the leap year is not detected anymore! I don't want much do I? :D