Help with my calendar!

[excelblackbelt]

Hello:

I am using this GANTT type calendar and I want to use the dates in 2012 and create more years like 2013 & 2014, but when I copied and pasted the section from Jan -Dec 2011 to the end and updated to 2012 it would not recognize the Feb 2012 dates...how do I update this from year over year...it worked back in the 2010 section, but not when I created a new year.

Here is a screenshot:



Thanks guys!

 

[jmthompson]

is it because 2012 is a leap year with 29 days in february?