Make a Dynamic Calendar and Track Important Dates

[ashahussein]

How do I replicate the month so that I have a worksheet with 12 months instead of one? I want them to all to be the same size but to have them appear one after the other as I scroll down the page? I want to be able to view the upcoming months. Also at 9:15, how are the cells being frozen? What buttons are being pressed?

[tmcdgreen]

Very simple to understand, great tutorial! Would be helpful if the formula box were zoomed into or displayed larger when you add new items.

[jillianrisse]

This was a super helpful tutorial. Thank you so much. Any suggestions on how to change formatting to a month-year drop down? So this can be used for past and future years (vs this year).

[Bajwa-krmr]

How do I get the years to update automatically? For example, I'm starting in Jan 2023 so my calendar view works through December. If I change the view to January, it goes back to 2023. I'd like it to go forward to 2024.

Kindly advise me. Thnx

[noorddinn]

Thank you so much, I have been looking for exactly this type of calender views for my inputs.

[sounduniverse]

Thank you so much.. just a question what if i have more than one task in single day ?

[TheINDELICATO]

How can I add a recurring event every month over years (car payment)? Where do I enter this formula

[TheMrNinzy]

Great work 8:50 what if I have multiple events but rather than alt&enter on one cell, what would it be when adding additional same date events added at a later time?

[alexisa-vevk]

Great video. If you had more than 1 event on the same day, but they aren't included in the same cell in your list of data, how would you make sure all events on that specific day are pulled into the calendar view?

[schevonemalatji]

Thank you for this great tutorial, quick question...is there a way to view all months on one page if I want to print the complete year calendar so share with someone?

[Its.DreaDre]

How do you make a recurrence date that happens every month? Like for instance car bill on every 14th?

[MaroonedAgainPL]

Thank you very much for this Guide! Best regards!

[ItratMemon]

great tutorial. wondering what the solution is for a range of dates? if i put in a range of dates in my date column, i.e. a 3 day period, then the entry in the calendar disappears altogether. how to i amend this?

[tkranz]

How do I get the years to update automatically? For example, I'm starting in May 2023 so my calendar view works through December. If I change the view to January, it goes back to 2023. I'd like it to go forward to 2024.

[russbishop]

I have a calendar set up and I want my monthly bills to appear as I change the month. How do I make this work?

[scottjones]

i tried the highlighting conditional formatting for football fixtures, but it only works on the 1st one i try, it will not work on multi dates, any ideas ..?

[MilicaStojanovic-un]

Video is great, its simple but I have a problem. When I do the same thing like you I don get anything, can you suppose what is wrong because I don't know, tried to find but whit no luck.

[angelitoarenas]

Great tutorial. 😍
How about we want to hardcode the year instead of current year. Thanks!

[Dre_La_Mont]

How do you make a notes cell under the date changeable by month? So if I click January I won’t see februarys note

[marksibert]

Wait a minute!!! I see where you put Nov 11 in one time with an entry next to it, and a blank date, with an entry, but the calendar pull up them both. How the heck did that happen?

When I put in the date two times, with corresponding info, the Match-Index pulled up one line. This confused me.