Calendar #REF error

[chazzer29]

Hello, I need help

I've used an Any year one month calendar template and which has come up with an error I can't fix.

so I opened the document and the array for the calendar has removed the start day selection from the formula this has made all other formulas error, I cant figure out how to correct this.

Has anyone got any idea as to a solution?

[#2]

@chazzer29 This particular template is full with named formulae, named ranges and all sorts of other trickery.

And, as it's name suggests, it's a "one-month calendar". Thus, not well suited to turn it into a 12-month calendar.

It's difficult to customise, easy to mess-up and difficult to repair. You picture shows both #REF and #NAME errors, suggesting that somewhere in the chain of named formulae, a named range is called that has been deleted.

Can you upload your file? Difficult to diagnose otherwise.