2024 Social Media Planner Calendar in Google Sheets [FREE Template]

TL;DR How to set up the social media planner
- Make a copy of the template (you need a Medium account) / new-2024-2025-beyond-s...
- Duplicate the tab & rename it to "Jan" "Feb" "Mar" or whichever month you're planning.
Changing 3 settings:
1. In D2, write the year you're planning out content for
2. In F3, select whether you want your week to start on Sunday or Monday
3. In the pink box in J8, take the first calendar week of the month you want to plan content for (e.g. for January 2024, take calendar week 1. For February 2024, take calendar week 5).
Done! :) All dates etc will update according to your settings. Happy post planning!
📈 GET the FREE template: / new-2024-2025-beyond-s...
✍🏼 Contribute to the blog with your own Google Sheets templates: / google-sheets
🤓 Support me on Etsy: www.etsy.com/de-en/shop/sheet...
I won't be updating future templates, that's why I shared templates for free for those on Medium and only for the symbolic price of ( little over) $1 on Etsy in case you'd like to support me financially

[@GoogleSheetsGeeks]

There's only a monthly version of the 2024 Social Media Calendar. You can set it up in just 3 clicks.
I won't be updating future versions. This is the final update of the template. You should be able to reuse it year upon year.
Thanks for the support!

[@chandrachester2149]

This is a straightforward template. I am not too versed in using Excel, but I get excited by the formulas and how everything comes together. Thank you for sharing it with us. One question. Would that mess up the formulas if I wanted to add a sheet to it just to keep track of my hashtags?

[@tinafayeschwahn]

This is exactly what I was looking for! Thank you so much for sharing your expertise and creativity!

[@katieatwoofieswo]

Thank you so much! It's so clean - I love it.

[@user-xw1fe4qj1o]

This is AMAZING...! Thank you so much! ✨

[@Hashirshaike]

Thanks for the content sister

[@m.ridhosaputra2989]

Thank you so much !, this is wonderful

[@reynardmhlahlo9864]

You are amazing, so glad I found you, thank you so much

[@glowupnook]

This is what i was looking for, thank you so much

[@LatriciaHenry]

Very helpful. Thank you!

[@shawnaamit7103]

This is wonderful, thank you

[@JenniferAnnBlair]

this is awesome! thank you

[@Nitshanda]

Hey, thankyou so much for this content calendar. it helps me a lot.

[@adammansueto10]

I LOVE U SM THANK YOU HUHUUUUUUUU 😭😭😭😭😭

[@faharsoudagar4067]

It’s really helpful ❤

[@KitSilva]

Thank you so much. I love you. You're an angel. :)

[@lucastoledo8317]

Thank You!

[@sarahallag5942]

Thank you 👏👏👏

[@LouyerEditors]

Thanks!!

[@miftahulhaera458]

Thanks a lot for your sharing, thats very usefulll, thank

[@aakashchudasma6060]

Thank you so much

[@nadanisrinaz]

Hi, thank you so much for the tutorial it's really helpful. 😊

[@GoogleSheetsGeeks]

Glad to hear 😊

[@Othmarohernandez]

thanks a lot I think really help me to start

[@GoogleSheetsGeeks]

Glad to hear :) Good luck habit tracking 🙏
Although I love perfect streaks, I don't have those every day, at all. But using the template as a reminder to do things that are good for you helps :)

[@creativevideos8236]

This is really helpful. Thanks for sharing this template. I've been using your template since 2022. Good to see the final version. Super easy to use

[@GoogleSheetsGeeks]

How cool, thank you! 🙏

[@ThisIsAliNazari]

in my country the week start from Saturday. How can I change it? Would you help me with that?

[@khanhnguyenquang1068]

What font do you use ? Tks

[@kellza1]

Hey thanks for this how do you get things to automatically update with the correct data based on selecting the week start - what’s the function?

[@GoogleSheetsGeeks]

It's a hacky way but I did this so you could all set up your own sheets in future and I wouldn't have to manually update them every year 😏

[@justbelit]

can you do a project/task management planner? say you're managing different teams or projects and need calendar reminders of specific tasks. how would this be created in a workbook

[@GoogleSheetsGeeks]

I don't have any sheets for this purpose yet! 🙏

[@SaraKamran-tr4cf]

my calendar does not show me The first week. how to find it?

[@user-hp6zg4wo1o]

Thank you so much. I am just wondering how am I able to see the the Calendar week on my Google calendar?

[@user-hp6zg4wo1o]

Nvm I got it thx :)

[@Veeartistry]

hey how did you do it?

[@GoogleSheetsGeeks]

Ahoii, how do you mean? The calendar week's always visible on Google Calendar, I manually added it to the Sheet

[@user-qs5iv4lp2m]

Hii, I really like this calendar, unfortunately when I download it to excel, everywhere where `Mon or Monday`stands turns to DDD/DDDD.,. how can I change??

[@GoogleSheetsGeeks]

Unfortunately I have no idea, I only work with Google Sheets🧐

[@Yuhna-d]

I don't even believe in God but.. you are God sent!

[@selvakumar5119]

If I plan to post multiple times a day, is there a way I can use this template?

[@GoogleSheetsGeeks]

A workaround: You could insert extra rows, only the mini calendars won't look that nicely.

[@JuanHernandez-cg9sf]

im having trouble changing the months that start on the same number, pls can you help me?

[@GoogleSheetsGeeks]

All you need to change is
- the year above
- And the calendar week in the pink box. Let's say you want to start your calendar in March this week. That's calendar week 10 (for 4 march to 10 March). Input the 10, and everything else will update automatically :)

[@GoogleSheetsGeeks]

the '10' goes in the pink box

[@Hyderabadi_girl9]

I'm unable to access it, it's asking me to upgrade

[@GoogleSheetsGeeks]

Did you try again? What upgrade do you mean?

[@gloryanusha3184]

I mean it is asking me to pay the amount to access it

[@parshuramgore25]

link is showing invalid

[@GoogleSheetsGeeks]

Did you try again? I checked it, it's working🙏

[@janiyaalessandra6835]

😔 'promo sm'

[@GoogleSheetsGeeks]

What do you mean?

[@user-mo1op5px9q]

Thank you so much

[@ricardosanchezf]

Thanks!

[@GoogleSheetsGeeks]

🙏

[@CatherineMullins-en4zb]

Thank you so much. I am just wondering how am I able to see the the Calendar week on my Google calendar?

[@GoogleSheetsGeeks]

I didn't look into that, this calendar's meant to use in Google Sheets only. But I'm sure there's a way to sync it to Google Calendar somehow