Year Planner Mod needed plz

Hi All,

I have a copy of a year planner that calculates the days of the month and adjusts them according to the year input into the header area.

Would anyone please modify it so that the first column reads August and the last column reads July (instead of Jan to Dec) and still maintain the calculations as required?

It will then be a viable academic calender.
Thanks in advance.

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?

Double post sorry

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

quich fix for first bit
delete text in H1 and replace with this formula
="- "& B1+1&" YEARPLANNER"

That gives me a circular reference warning :O Oh you typed H1. My bad :D
Very sneaky and very nice Thanks

the second bit is at bottom of sheet you have the field where old chippy says enter start date
the numbers c47:n47 must match the number of days in month so change them
with the exception of february which needs this formula instead
=28+FLOOR(1/(B1-FLOOR(B1/4,1)*4+1),1)

cant see how colour is put in cell if i change the colour it does so ,so its not done automatically by format.
on my lotus organiser planner i have to manually put in bank hols. not to say it couldnt be done with a list of hols and cf but you have already reached max cf of 3 in some cells.

sorry what bit we looking at? ive only looked at first sheet "planner" repost workbook with where your up to now

ok had to adjust feb because formula was looking for start year not end year thats why
also changed the way it works just put year in b1 the rest sorts itself out. fingers x'd

Hi Guy's

I was trying to get it finished last night before going to bed and I see you may have spotted that February could have 31 days

I've read thorough your posts and I've added Martin's formula

="- "& B1+1&" YEARPLANNER"

And also altered the formula's in row 47 to get the dates per month

Sgt.Trojan - you only need to enter your start date in cell F45 starting on the 1st

Hi,

Is it worth looking at one of these and making it suit your requirements? May be the Yearly Calendar with Week Numbers?

http://www.vertex42.com/ExcelTemplat...-calendar.html

Hi,

Happen to come across some calendars yesterday here and used one to modify to your requirements, hope it's not to late?

yippee!!!!!!!!!!!!!