Would appreciate some help on this one.

From Office.com Templates I've downloaded the calendar "Family calendar (any year, Mon-Sun)

I've changed the layout so that it runs on the financial year from 1st April to 31st March. But I'm struggling to get the January to March section to display the correct days for the following year. - As in to say, in the 2015/16 calendar, I need Jan to March to match 2016 days to dates.

the formula for January is

=IF(DAY(JanSun1)=1,"",IF(AND(YEAR(JanSun1+1)=CalendarYear,MONTH(JanSun1+1)=1),JanSun1+1,""))

So what do I need to change in that formula to get it displaying the next year's dates on the right days?

thanks

1) On the Formulas tab of the ribbon, click Name Manager.

Change the definition of JanSun1 , FebSun1 and MarSun1 to

=DATE(CalendarYear+1,1,1)-WEEKDAY(DATE(CalendarYear+1,1,1))+1

=DATE(CalendarYear+1,2,1)-WEEKDAY(DATE(CalendarYear+1,2,1))+1

and

=DATE(CalendarYear+1,3,1)-WEEKDAY(DATE(CalendarYear+1,3,1))+1

respectively.

2) Select the ranges for January, February and March, including the empty row below March.

Press Ctrl+H to display the Replace dialog.

Enter CalendarYear in the Find what box, and CalendarYear+1 in the Replace with box.

Click Replace All.

Absolutely Brilliant. thanks for your help, Hans

Managed to complete Step 2 OK. But on step 1 I had to Edit the "BlankCalendar"! lines before the second CalendarYear would save.

thanks again :)

If I wish January to March to display the year after the month - what would I need to add to the formula of

=DATE(CalendarYear,1,2)

=DATE(CalendarYear,2,1)

=DATE(CalendarYear,3,1)

thank you :)

Step 1: To take into account that January, February and March are in the next calendar year, change the formulas to

=DATE(CalendarYear+1,1,1)

=DATE(CalendarYear+1,2,1)

=DATE(CalendarYear+1,3,1)

Step 2: Change the number format of these cells from mmmm to mmmm yyyy.

Hans, you are an absolute star

thank you so much