How to change the names of Months in a calendar without breaking it?
Our take
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?
[link] [comments]
Read on the original site
Open the publisher's page for the full experience
Related Articles
- Correct VBA format for changing multiple sheet tab names in a workbookHello! I am trying to change several worksheet tab names. From Googling I see that I can use a VBA to batch change an entire workbook's tabs. I'm not sure what language to use to execute this change successfully. I have designed a planner that I intend to print out. Name format is: Month Date - Left/Right (depending on which side of the binder the page will sit when open). I want to change "April" to "May." (An individual workbook for each month of the year.) How would I set the VBA up to rename each of the tabs? https://preview.redd.it/6m4moy8y3stg1.png?width=929&format=png&auto=webp&s=adea271f20c07a8bbe805705a04b146eda0dc4e0 submitted by /u/joeyjacobswrote [link] [comments]
- Trying to create a spreadsheet where cells are highlighted if name of month typed matches current monthI'm trying to create a spreadsheet for our office manager to help keep track of birthday months and anniversary months of employees. What I'm trying to do is create a row in which employee birthday months are typed (March, April, etc) - and not exact full dates. I want to create conditional formatting where all of the text values that match the current month are green, so she can scroll through each month and make a quick list of anyone with a birthday/anniversary that month. We will not have full birth or anniversary dates, just the name of the month. I have tried all sorts of formulas from google searches, to no avail. submitted by /u/Myworkaccount918 [link] [comments]