How to create dynamic Calendar in Google Sheet

Рет қаралды 11,480

Күн бұрын

Пікірлер

@__MARKR__ 3 ай бұрын

Very helpfull! I started with the default Google Spreadsheet Calendar template, but I wanted to create dynamic months exaclty like you showed. And the formulas of the template are much more complicated. Like you can read in several reactions I placed on other comments in the list, I did encounter some challenges, but the advantage of such a simple design, is the increased flexibility to slightly change the approach and still be able to get the desired result. So all credits to you sir for this fine example. Learned several things by using it.

@jillismyname 3 күн бұрын

Thank you so much. I just made mine!

@NeotechNavigators Күн бұрын

Most welcome

@vudao58 Жыл бұрын

great video. Thank you for sharing!

@NeotechNavigators Жыл бұрын

Our pleasure!

@pasticciottiontheroad Жыл бұрын

Thank you very much, this was very helpful.

@NeotechNavigators Жыл бұрын

Most welcome

@bhactivities 9 ай бұрын

I got an error message at 3:00ish saying that '1-' cannot be parsed as a date/time. I used " but the error message used '. Maybe Google has a glitch today?

@LanaLittle 7 ай бұрын

Make sure you have values in D3 and D4 - formula has to have something to read

@fragrenceful 10 ай бұрын

Great video

@NeotechNavigators 10 ай бұрын

Thanks 🙏

@noeter 10 ай бұрын

Love it, but please explain, newbie here, why we have to minus 1 and plus 1 on a weekday formula?

@srinivasgoudmanthapuri2719 Жыл бұрын

👌👌

@NeotechNavigators Жыл бұрын

Thank you

@juliari9697 4 ай бұрын

Why the format always not working for my sheet

@JojiDavey 7 ай бұрын

Thank you for making this process so easy and straightforward! Is there a way to highlight specific dates? Im trying to "blackout" specific future dates, but when I do it effects every month in my calendar. Thank you in advance!

@__MARKR__ 3 ай бұрын

You could use conditional formatting, but you might need to tweak the formula. Something like: =COUNTIF(,) > 0

@noeter 5 ай бұрын

My date won’t much the day of my calendar if I add 1, could you please explain further why + 1? I chose this year, 2024 but 1 won’t work, I added 6 to correct the date. Could you explain the formula of adding 1 please, thank you.

@AnysNadhilah 6 ай бұрын

what if i want to start the calendar on Monday?

@__MARKR__ 3 ай бұрын

I've actually just done that :) Set the first column on Monday, but instead of "+1" you need to use "-5" =SEQUENCE(6,7,D5-WEEKDAY(D5)-5) Note that this might lead to an empty week to start with... Whereas the original solution leads to an empty week at the end of the month.

@duazaitoun Жыл бұрын

😊THANK YOU SO MUCH

@NeotechNavigators Жыл бұрын

Most welcome

@kmanoj392 Жыл бұрын

Nice

@NeotechNavigators Жыл бұрын

Thanks🙏

@desbullard26 4 ай бұрын

Hi! This is a very helpful video! I am trying to create a social media calendar and it would be helpful to have three rows in between each week of dates where I could add social media details for each date. Is it possible to build this calendar and add the extra space? I tried simply adding rows, but obviously that didn't work. Lol

@__MARKR__ 3 ай бұрын

Yes you can. It's a little more work though. Instead of using the =sequence(6,7) formula, you need to use 6 seperate ones. Also, the starting point of the calendar (i.e. the day of the week) is important too. In case you start on the Sunday like in the example, use the following Sequences: =SEQUENCE(1,7,D5-WEEKDAY(D5)+1) =SEQUENCE(1,7,D5-WEEKDAY(D5)+1+7) =SEQUENCE(1,7,D5-WEEKDAY(D5)+1+14) =SEQUENCE(1,7,D5-WEEKDAY(D5)+1+21) =SEQUENCE(1,7,D5-WEEKDAY(D5)+1+28) =SEQUENCE(1,7,D5-WEEKDAY(D5)+1+35)

@frazled Жыл бұрын

Great work, How would you add data from another sheet / cell into one of the cells without breaking the functionality?

@NeotechNavigators Жыл бұрын

Great suggestion! will add the link soon.

@desbullard26 4 ай бұрын

@@NeotechNavigators Did you happen to share this solution?

@__MARKR__ 3 ай бұрын

@@desbullard26 Just click the other sheet when you are to select the range of years or months. Google Spreadsheet will automatically add the sheetname.