How can I locate the "Month and Year" sheet in numbers Calendar Template?
Hello,
I am looking to incorporate the monthly tables from the Calendar template into a larger work sheet i am working on, so I can edit them as I need alongside other data they need to sit along.
However, when copying the tables, I noticed that not all the formula will copy along. Specifically the WEEKDAY formula, which the whole month day schedule is linked to won't copy, as it appears it's linked to a "Month and Year" sheet, which I don't seem to locate. As a results, when copying the months in a different file, I can change the months, but the weekly days won't change accordingly.
Would you be able to tell me how I can locate the "Monthly and Year" sheet and if it's possible to copy it into another file, so to ensure the monthly tables work?
I include a photo illustration to support my question.
Thanks for the help!
Cinzia
MacBook