How to Create a Month Calendar in Excel - Tutorial 📆

Excel tutorial to learn how to create a calendar in Excel. We’ll make a month calendar in Excel that you can recreate for any month, for any year. We’ll create the calendar so that it’s fillable and printable.

To learn how to format a calendar in Excel and also create a marker for the current day using conditional formatting, make sure to watch my follow-up video tutorial -

and

To learn how to add a background picture that you can print to your calendar, watch this short tutorial -

*FYI:

Thanks for watching this Microsoft Excel tutorial and, don’t forget, if you like this video, please “Like” and “Share” with your friends – it really helps us out 😊

Thanks!

*DISCLAIMER: This video description contains affiliate links, which means that if you click on one of the product links, I’ll receive a small commission. As an Amazon Associate I earn from qualifying purchases. This helps support the channel and allows us to continue to make tutorials like this. Thank you for your support!

#YAcostaTutorials

[ebriggs]

Excellent tutorial! Would you please show how to format a side by side (horizontally) calendar? For my job I need to see Jan next to Feb, March next to April, etc. I struggle at formatting because it's been over 10 years since my classes in Excel. I don't use it much at work and have forgotten almost everything!

[kimberlymitchell]

This was an amazing how to video thanks!

[uittyman]

Well done, thank you I was able to do so in excel on my Google drive

[anupamabhatt]

Thank you for the video :) It is very helpful.

[tarekhasan]

it's very use full video. i like this.

[alexagachaclubvv]

you didnt show the steps how youve done all the boxes i just have made the boxes on top but i dont know now how to put it on the bottom.

[FranSa]

Love Your Tutorial! 👌 I'm hoping you will be able to help me create a one-month page, 6 x 9, with Year, Month and Days Blank to be filled in after being printed..
(6 Weeks. 7 days). I also need to fill in each day with the same information, leaving the last four spaces at the end of the month to add Clip Art Pictures... I hope I have been detailed enough with this request... Thanking you in advance. 🤗 Stay Blessed. 🙏

[LiveTUNA]

I am really confused on how you are copying it down to the end of the row when you are referring to the days. I am really green with excel.

[danilomanzano]

Could you enter 10 or 8 names of birth day celebrants per day?

[pomi]

How to change cm to inch in page layout...

[SanviPatil]

nice video.. madam ur voice like as leaila gharani

[ednabustamante]

How can I remove Saturday and Sundays?

[maanasjoshi]

2:58 what did you do here I am really confused

[theohaywood]

How do I set the margins on my tablet because my tablet won't let me do it. do I need a laptop in order to change the margins because I have tried every way possible to try and change the margain sizes. its really frustrating. Can anyone help me please ?

[Devanetworks]

How did you magically fill up the boarders? Is frustrating me 🤦🏻‍♀️

[SanviPatil]

madam ur name Leila .? xelplus channel

[stephaniecoull]

Who knew there was 28 days in February

[OngoGablogian]

My calendar when absolutely mental when I tried to drag the column to fit the page. Keeps giving me a calendar that 50 meters wide.

Edit: God, now you've really lost me with the borders. Fck this. I wish Excel was a person so I could punch it in the face.