Need help fixing calendar (leap year)

Hi! I'm new here. I have attached a sheet that is driving me crazy. you will see two tabs. one for 2016, and one for 2017. In creating the 2017 tab, I merely copied 2016 forgetting about leap year. Now everything starting on the 29th of February is screwed up. Can someone take a look at it for me and fix? or tell me how to fix? thank you so much!

In the formula tab go to Name Manager
For the names Jansun Febsun etc add +1 right after te Jansun, febsun etc
so JanSun changes from =DATE(CalendarYear,1,1)-WEEKDAY(DATE(CalendarYear,1,1))
to
=DATE(CalendarYear+1,1,1)-WEEKDAY(DATE(CalendarYear+1,1,1))

Originally Posted by philaugust2004

In the formula tab go to Name Manager
For the names Jansun Febsun etc add +1 right after te Jansun, febsun etc
so JanSun changes from =DATE(CalendarYear,1,1)-WEEKDAY(DATE(CalendarYear,1,1))
to
=DATE(CalendarYear+1,1,1)-WEEKDAY(DATE(CalendarYear+1,1,1))

Thank you!!!

You're welcome. Glad it worked