1 min readfrom Microsoft Excel | Help & Support with your Formula, Macro, and VBA problems | A Reddit Community

How to change the names of Months in a calendar without breaking it?

I'm using the Google Sheets Annual Calendar template and I want to be able to change the names of the months for a tabletop thing, but doing so breaks the entire thing. I can't find another year calendar template spreadsheet that's this well-organized and all on one page.

The function each square in the calendar uses is this;

=IF(E4<>"",E4+1,IF(WEEKDAY(DATEVALUE($Z$1&$B$2&1))=5,1,""))

Or something similar.

I just want to change the real month names into some silly fantasy variants to make stuff easier to track, but nothing comes up on google for "Year calendar that does not use scripts" or anything of the sort that I can actually use. Is there an easy way to just, I dunno, change what's displayed in the field without changing the actual variable (in this case, the month's name) or something?

submitted by /u/TheodoreMcIntyre
[link] [comments]

Want to read more?

Check out the full article on the original site

View original article

Tagged with

#google sheets
#Excel alternatives for data analysis
#natural language processing for spreadsheets
#generative AI for data analysis
#rows.com
#modern spreadsheet innovations
#machine learning in spreadsheet applications
#enterprise-level spreadsheet solutions
#digital transformation in spreadsheet software
#Excel compatibility
#collaborative spreadsheet tools
#AI-driven spreadsheet solutions
#cloud-based spreadsheet applications
#real-time data collaboration
#automation in spreadsheet workflows
#no-code spreadsheet solutions
#AI-powered spreadsheet
#real-time collaboration
#Excel alternatives
#spreadsheet API integration