I'm so excited! I'm planning on making a monthly meal planner with drop-down fields to pick from a list of recipes so this setup is PERFECT! The only thing I changed was the date formatting. I wanted the dates (numbers) for the previous and following months to be hidden so i had to add 2 formulas in conditional formatting, but it only took a second to figure it out. I literally did a happy dance in my chair when i was finished building the calendar lol. Thanks so much for the very helpful tutorial.
@spreadsheetlifeАй бұрын
That is so amazing!!!! First of all, way to go on finishing the tutorial! Second of all, it's so awesome how you were able to change things to fit your specific situation too. Thank you for letting me know how it went. I love to hear stories like this, and it's incredible to know my video has offered so much value for you to use. 😊
@NicasioPineda9 сағат бұрын
Easy to Follow Great
@spreadsheetlife2 сағат бұрын
So glad you found this easy to follow! 😄
@renatokoller13262 ай бұрын
Hi Ryan, thank you for such a great video! Unfortunately the formula =DATE(C3,MATCH...) doesn't work in my excel. Do you have any solution for that? Thank you very much in advance!
@spreadsheetlife2 ай бұрын
Where are you located? If you reside in a country that uses a comma as the decimal separator for numbers rather than a period, then your Excel formula syntax may use semi-colons instead of commas as the argument separator. So try using semi-colons instead of commas. That might be the issue.
@RearsilverGaming2 ай бұрын
That was great thank you! The conditional formatting formula didn't work for me though so just created 2 rules, one for date occurring last month and one for next month
@spreadsheetlife2 ай бұрын
I'm so glad you enjoyed the video! I'm sorry you couldn't get the conditional formatting to work, but I'm glad you figured something out.
@RearsilverGaming2 ай бұрын
@@spreadsheetlife Keep up the great work!
@spreadsheetlife2 ай бұрын
I'll do my best! 😊👍
@09thezodiacАй бұрын
I had the same issue but when I went back into Conditional Formatting to edit, I pressed Stop If True for the MONTH(B7) Formula and it worked.
@ladyfingerhandmadeАй бұрын
@09thezodiac oooh! I ended up making 2 formulas like OP, but I'll keep this tip in mind for the future. Thanks!
@danirami7322 ай бұрын
Exactly what I needed. Thank you so much!
@spreadsheetlife2 ай бұрын
That's so amazing to hear. Thank you for watching! 😊
@albertvannikerk66652 ай бұрын
That is exactly what I was looking for. Thanks a million.
@spreadsheetlife2 ай бұрын
Awesome!! Super glad to hear it! Thanks for letting me know. 😄
@Bjorg203 ай бұрын
Hello Ryan, Thank you so much for do this organised calendar, I am struggling with the formula first one Text saying Left then =Date(C3 as etc I am unable to get that to work, what should they left bar say in formula form? When I do = and given formula it gives me error saying I need to put ' at the front, that doesn't work either...? Are maybe able to do the formula so I can copy it into my sheet...? Thanks a million for doing this for us amateurs
@spreadsheetlife3 ай бұрын
Hi there! I'm super glad you've enjoyed the video, but I'm sorry that you're struggling with the formula. To make it easier for me to help, send me an email at info@spreadsheetlife.com. Attach your file, and remind me what you're struggling with in the email.
@Bjorg203 ай бұрын
@@spreadsheetlife I’ve just send you an email…🤞🏻
@spreadsheetlife3 ай бұрын
I got your email. You can expect a response here in a little bit!
@Bjorg203 ай бұрын
I just wanted to express my deep gratitude for the extraordinary assistance you provided. Your valuable insights have truly opened my eyes to a fresh perspective, and the individual behind the KZbin channel is a remarkably humble person. I never anticipated receiving such overwhelming support from you. Your kindness and generosity are truly remarkable. Please continue to inspire others with your outstanding work. 👩🏻💻
@spreadsheetlife2 ай бұрын
You just made my day. Thank you so much for your kind and heartfelt words. They mean so much to me and really encourage me to keep going and give it my all to create the best content I can. 😊
@pandharinathjoshi65652 ай бұрын
Excellent training your explanation is too good sir
@spreadsheetlife2 ай бұрын
I'm so glad that you enjoyed it! 😄
@terrymartin9793 ай бұрын
This is perfect and exactly what I need! However, I can't get the prior month to grey out. Do I type in MONTH manually, or is there a specific button I should click when writing the formula.
@spreadsheetlife3 ай бұрын
So awesome to hear!! 😄 As for the conditional formatting formula to get the prior month to grey out, you have to type in MONTH manually when writing this formula. And be sure that you have your references and the dollar signs correct as well.
@QeysLucky4 ай бұрын
Excellent teacher
@spreadsheetlife4 ай бұрын
😊👍
@NajK-833 ай бұрын
Thanks alot,. Can you add hourly appointments (time input) and highlighted on the calendar?
@spreadsheetlife3 ай бұрын
I found your other comment for the part 2 video and gave you a response there. 😊👍
@terrymartin9793 ай бұрын
EUREKA! I figured it out! Thank you so much for making this video!
@spreadsheetlife3 ай бұрын
Thanks for watching! I'm so glad you enjoyed the video and also figured it out! 😄
@dauntlessarte61904 ай бұрын
This is what exactly what I was looking for. Thanks!
@spreadsheetlife4 ай бұрын
That's amazing!! I'm so glad you came across this video! 😄👍
@ΒασΚων9 күн бұрын
I would like to ask something. When I write something in one cell of the calendar, and then change the month, it shows in the next one. That is, if I write something on January 10th, it will be there in February as well as in all the months. How can I write something in a cell, and it does not carry over to the next months? Thank you very much
@spreadsheetlife9 күн бұрын
Good question. See part 2! kzbin.info/www/bejne/kHeriYaXrt9_rKs In part 2, I show you how to add events that will also change when you change the month and year.
@ΒασΚων8 күн бұрын
@@spreadsheetlife in the last steps i type =INFA(IF(VLOOKUP(B7;Events;2;FALSE)=0;"";VLOOKUP(B7;Events;2;FALSE));"") ...but it shows me #ONOMA? (ONOMA is "name" in Greek). am i doing something wrong ?
@spreadsheetlife8 күн бұрын
If you are seeing that error, it may be a compatibility issue. Are you working in an older version of Excel? Change the IFNA function to IFERROR instead. Let me know if this fixes the problem.
@ΒασΚων8 күн бұрын
@@spreadsheetlife wow !!! yes !!! problem solved... thank you very much !!!
@spreadsheetlife8 күн бұрын
You're very welcome! I'm so glad that we figured it out!! 😄👍🎉
@charmainmogere5562 ай бұрын
This is amazing 🎉🎉🎉 thank you
@spreadsheetlife2 ай бұрын
Yay!!! 😄👍 You are very welcome. Thank you for watching!
@joeroper3730Ай бұрын
How would I edit the formula to create a calendar to just show week days (Monday to Friday) thx
@spreadsheetlifeАй бұрын
It would require a few different changes and adaptations to the formulas. If you send me an email at info@spreadsheetlife.com, I can give you some ideas.
@amandabiggs14062 ай бұрын
This was one of the easiest tutorials that I have followed! Great job!
@spreadsheetlife2 ай бұрын
That's so amazing to hear! I'm so glad you found the tutorial easy to follow. Thanks for watching and for your kind words! 😊
@chunwingoscarpoon2643Ай бұрын
Excellent! Thank you for your tutorial. Highly appreciate!
@spreadsheetlifeАй бұрын
I'm so glad you enjoyed the tutorial. Thank you for watching! 😊
@intanmaristiarafuzylestari2 ай бұрын
Thank you❤
@spreadsheetlife2 ай бұрын
You're welcome!! 😊
@ValGianan4 ай бұрын
Wow! Can u do this in google sheet?
@spreadsheetlife4 ай бұрын
Yes, for sure! Check out this video! kzbin.info/www/bejne/mKjGppqerrhohrM
@carol-annepeacock94803 ай бұрын
is there a way to colour code the events please?
@spreadsheetlife3 ай бұрын
Hi there! I found your other comment for the Part 2 video. I gave you a response there. 😊👍
@jacirajose298123 күн бұрын
the first formula is wrong, even using ; instead of , i stopped there
@spreadsheetlife22 күн бұрын
I'm so sorry you're struggling with the formula. If you'd like, post your formula here and I can take a look at it for you. 😊👍