Ho do I change the formula for this calendar to show months and years?

Hi,

I have come accross this calendar online and it suits my requirements, however, the month s currently static and the year is dynamically controlled by a spin button.

The formulas in the relevent days are as follows

Day 1 =IF(AND(YEAR(JanOffset+1)=calendarYear,MONTH(JanOffset+1)=1),JanOffset+1,"")
Day 2 =IF(AND(YEAR(JanOffset+2)=calendarYear,MONTH(JanOffset+2)=1),JanOffset+2,"")

and so on, I need the formula and the spin button the also change the month as well as the year.

Please see attached file for details.

Cheers

JD

Hi, I need the month to change through January to december for each year as well please.

Cheers

JD

hi,see if help you

calendar-wcymiss.xlsx

Hi great solution but it dosent seem to advance the month in the text box at the top of the calendar

JD

Also is it possible to compact everything into one spin button?

Cheers
JD

Hi AZ-XL that did the trick for the displayed calendar title showing the monthe and year, thanks.

Cheers

JD