Year Planner Mod needed plz

Yes, I am on "planner" too.

As the sheet stands (attached below) it has been modded as per the posts above. The displayed dates are correct but only for Year 2009-2010.

If you change the year in Cell F45 to 2008 (for example) and then check a random date in 2009 (say May Day Bank holiday) you can see that the date is not correct (one day out infact). Change the year to 2010 and it also provides incorrect dates so I assume that it would not be correct for other years. It seems to be the dates in jan to july that are the problem.

It does pick up the leap years now though.