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.
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!
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
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)
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.
@@desbullard26 Just click the other sheet when you are to select the range of years or months. Google Spreadsheet will automatically add the sheetname.
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?
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.
![2024 Social Media Planner Calendar in Google Sheets [FREE Template]](/img/n.gif)
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.
great video. Thank you for sharing!
Our pleasure!
Thank you very much, this was very helpful.
Most welcome
Love it, but please explain, newbie here, why we have to minus 1 and plus 1 on a weekday formula?
Great video
Thanks 🙏
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!
You could use conditional formatting, but you might need to tweak the formula. Something like:
=COUNTIF(,) > 0
👌👌
Thank you
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
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)
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.
Nice
Thanks🙏
Great work, How would you add data from another sheet / cell into one of the cells without breaking the functionality?
Great suggestion! will add the link soon.
@@NeotechNavigators Did you happen to share this solution?
@@desbullard26 Just click the other sheet when you are to select the range of years or months. Google Spreadsheet will automatically add the sheetname.
😊THANK YOU SO MUCH
Most welcome
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?
Make sure you have values in D3 and D4 - formula has to have something to read
Why the format always not working for my sheet
what if i want to start the calendar on Monday?
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.
Hi how to solve this error. i HAVE ERROR coming out after i entered the formula
DATEVALUE parameter '1-January2024' cannot be parsed to date/time.
ME TOO
Make sure you have the values selected in D3 and D4 so the formula has something to read