Create a Dynamic Calendar with To-Do List in Google Sheets | Step-by-step Tutorial

[@FuukoJournal]

Hello everyone, I have received some questions about why the days of the week do not automatically change when selecting a month, as per my instructions. I'm very sorry that you're experiencing this issue. I've reached out to some of you to get the file links, but since I haven't received any, I'm not entirely sure about the root cause of the problem. I guess it could be due to one of the following reasons: 1. Different language settings in Google Sheets: For example, the sheet I'm using is in English (United States), so the days of the week are displayed as Sun, Mon, Tue, Wed, etc. In other languages, these might be different. For instance, in Vietnamese, it would be CN, Th 2, Th 3, etc.; while in Spain, the days would be dom, lun, mar, mié... To check this, you can use the formula =TEXT(B4, "ddd") to see what the first day of the month is and compare it with the English system ("Sun, Mon..."). If it doesn't match, this might be the issue. You should then adjust the days of the week from columns D2 to Q2 to correspond with your language. If you prefer to use the English system, go to "File", select "Settings," and change the "Locale" to a country that uses English (like the United States). After that, press F5 to refresh the page. Note that it may take some time for Google Sheets to update the language settings. 2. Spelling and order of the days of the week: Ensure that the days of the week are correctly spelled, abbreviated to three letters, and in continuous order. It would be quite illogical to enter "Sun" and then "Tue" instead of "Mon", right? Thank you! 😊😊

[@user-vl6nj4db5m]

Great!

[@FuukoJournal]

@@user-vl6nj4db5m thank you so much

[@ajprila9904]

Whenever I switch month to Feb. (2) the numbers (Calendar days) on the table go missing. Similar to some of the other months like 8,9,11 & 12 but the rest are okay. Why is that?

[@FuukoJournal]

Hello, Thank you for your interest in my video. I apologize for the issue you’re experiencing. I’m not entirely sure what the problem might be, but let's try troubleshooting it together. First, please check the month of January. Are the days correctly displayed according to the corresponding weekdays? If not, there might be an error somewhere in your setup. You need to follow the instructions I provided precisely. In case you still can’t resolve the issue, if you don't mind, you can share the link with me via my email at [e-mail], and I’d be happy to take a look to help you figure out what’s going on.

[@FuukoJournal]

Hello, I just wanted to check in-have you been able to resolve the issue? I've been looking out for an email notification but haven't seen one yet. If you haven't resolved it yet, feel free to send me an email, don't hesitate.

[@FuukoJournal]

Don't forget to subscribe to Fuuko Journal for more exciting content! Click the link and join our community today! www.youtube.com/@FuukoJournal/?sub_confirmation=1

[@melissa-lynnpenney3318]

Following along, but no numbers appear when I put in the formula 😢

[@FuukoJournal]

I'm sorry to hear that. Have you been able to solve the issue yet? If not, please feel free to share the link to the file via my email at "[e-mail]." I would be happy to check it for you.

[@khanhanle9431]

help me! Is there something wrong with the function that 1/1/2024 doesn't give the number 1 on Monday but gives the value false =if(D3"";D3+1;if(text($B$4;"ddd")=F2;1;""))

[@FuukoJournal]

Hello, Thank you for watching my video. Based on your formula, I noticed the difference in using ";" and ",". So, I assume that the language setting for your Google Sheets is in Vietnamese. This means that your calendar headings should not be in English but in Vietnamese, specifically "CN, Th 2, Th 3, Th 4, Th 5, Th 6, Th 7". If you prefer to keep the headings in English, you need to change the language setting of your Google Sheets to English. Go to File -> Settings to make this change. I wish you success!

[@khanhanle9431]

@@FuukoJournal thank you very much❤‍🔥❤‍🔥