You have no idea how long I've been trying to find or even create a simple calendar template in sheet which doesn't involve Appscript. Thank you so much.
I've been struggling for more than 4 hours trying to mark events dates in the calendar, and you just saved me time with this clear and perfect tutorial, I must say that I learnt most of Google sheets formulas from your channel, thank you so much, you have a great method of teaching and make those formulas look simple :)
Man! Once again you bring solid gold to the sheets realms! Thank you for your great work and thank you for teaching us how to do it as well! Appreciate cha!
Really great video! Just what I needed. I would also like to be able to select the date in the heading to get the correct month. Thanks so much for a clear explanation and example.
Thank you very much ❤❤🎉 this really really helps a lot... But I'm facing some struggle.. I've made the conditional formatting to the first day and the cell under it, as you have explained, BUT when I go copy and paste that to all the rest I get them allll at that color.. instead of only for the days aren't included at the month...😅😢 how can I solve that.. Bear in mind I do special paste& format only .. I don't know why..
Thank you! In the "Add Holiday" portion, can you add to the formula to include a column b with the holiday discription that will display the holiday name in the same cell?
Hello, is there a way that the events on the calendar becomes color coded depending on who adds the event? We are using this as a shared family calendar.
I found it a good idea, for me, to include fields to remind me of bills to pay, or for my business, when I have money (that should be) coming in. Basically, and bills-payable, or bills-receivable, calendar all in one place.
Hey, This is so amazing, but one question: How do you slow the problem with transfering it to a monday to sunday based calendar? (Not sunday to saturday). I espescially mean with the month june 2025 where june 1 is disappering. It has something to do with the "weekday()" command, which sets sunday as value 1 and saturday as value 7. I want sunday to have value 7 and saturday as value 6. :)
I've been kind of making my own calendar but not like this to help me know which day I work with 2 jobs. is there a way to highlight am time in one color and pm in another in the formula?
Hey! Thank you so much for all this information, I want to ask, I'm using this calendar to manage all the events for the company I'm working for, and they asked me if I could highlight in one date 2 different events, so they can difference which area is in charge of those events by the color of the highlight Is this possible using a formula? Thank you in advance.
This was very hepful. I ran into an odd issue. I created an event for October 30, but It's only populating in the shadowed October 30 Day in the November Calendar. Do you know what I might've done wrong? The issue only seems to exist in the October calendar.
This is amazing!! BEST video on how to work with calendar function! Is there a way to create a filter for a range of dates?? I want to indicate when certain people will be out of our office and I know I can add EACH date and have it show up - but I imagine I would have 2 columns (start date, end date) and I would want to assign a custom color to each "boss". That seems like it should be do-able, but not sure where to start?
this is brilliant and I have got it to work correctly. Now I need to take it a step further and do this with a weekly schedule, so that the correct event goes into the correct time slot on the correct day - how can I do that?
FIRST OF ALL: WONDERFUL VIDEO, it has been extremely helpful and I learned a lot!! I do have a question; When the text is joined, by any chance is there a feature that can color text to code different events in the calendar? For instance, I'm putting my bills in the calendar with the list "Details" & "Details Sorted"; however, I would like to be able to color code the bills on my calendar so I can see (blue) wording or (blue) background for all of my credit card payments and (green) for all of my insurance payments, (orange) for all of my subscriptions, ETC....
Nice calendar, and I did almost verything you recommended, but I don't know why when I added another condition to the filter, my previous working data disappeared. I wanted to use another column that had a word in it. Some rows had the work bank, others had loan, others had interest, and sometimes they had the same date. But when I set it up for the word "loan", the detail info I wanted to show went away. What am I doing wrong? Thanks.
This is a great tutorial. I am however, struggling with the "Add Details" part of this. I was able to get it to work on one spreadsheet. Then I copied and pasted the formula to another spreadsheet and it did not work in the second one. Any thoughts on why that might be?
Hello, I have difficulty adding a new line to the Join events step. Since my iPad has no Alt+enter function key. Could you please help me any other way to make all the events in order?
is there a way to input data that has repetition or let’s sa it automatically calculates the position like every first friday of the every month. is there such a formula? thanks
Would you be able to tell me how I could add a date range into the calendar? For example, if I have an event that would be multiple days how could I show that on the calendar?
I followed everything in this video to the T. I'm having issues seeing the event description on the same day as a holiday. Please let me know how I can resolve this.
Great video - I had an idea to make a running total, solvency type sheet for a bank account balance that would look like this. Mainly to keep track of when things were coming and going from a checking account to be sure it doesn't pass 0. Particularly with withdrawals that will always be on the same day of the month, and biweekly paychecks. The details tab in this video seems like a great way to do this if you add some running total functionality.
Hello, At ERP Launchpad, we can help you automate your business according to your custom requirements by creating a cloud-based web portal and creating some extremely user-friendly modules for your business. If this is fine with you, do give us a reply.
Hello. Could you help me, if i need put events for several days, so i need start and end date. and what if there are several departments could add events. if u have some other videos?
How can I create a calendar of 2 days only? It's for a school, since every group studies only twice a week. I want to create one that has for instance just every Friday and Saturday.
@@ExcelGoogleSheets Thank you. One more question please. If there are let’s say more details of tasks of a specific day, any idea to display details of that day in a big space under the calendar table or in a separated sheet once I click on that desired day 🤔. Thank you🙏
I'm completely lost on very last step where just copy the formula and paste it to all cells. it will not automatically populate the task on that day, and when i tried to paste it, the border line disappears too. couldn't figure out why
Thank you very much for this great video! I am trying to insert holidays that start at a date, and end at another date, so I replaced "cell = date" to "AND(cell=CellRange2)", but something isn't working; is there any restriction for using AND with Cell Ranges?
@@Zzjul Yes, I did... Did you manage to solve the problem you're facing? I'm ready to help if needed, I'm available on LinkedIn if you like to connect...
How you can maintain details about January only in this month? The reason is because when a select february, details appear also in this month as a error.
First time trying this out. I keep getting stuck with an error while building the formula (either value error or won't display correctly). My use case is a bit unique though with an editorial calendar of 20+ posts a day. And I need to build upon it further with dropdown menus as well (if 'dropdown option a' then 'parse to calendar', if 'dropdown option b' then 'don't parse to calendar' kind of thing). Only been at it two days but so far I'm loving the journey and I'm determined!
Awesome content! Edit: I wasn't looking for it when suddenly your tip about custom formula caught my attention. Is it possible to make a video only teaching custom formulas for conditional format and custom formula for pivot tables? I always get stucked whenever I've got to use something like that. Custom formula is mayhen for me.
Hello, At ERP Launchpad, we can help you automate your business according to your custom requirements by creating a cloud-based web portal and creating some extremely user-friendly modules for your business. If this is fine with you, do give us a reply.
Hi! I didnt find any youtube video that can answer my problem 1. A cell that has name (like in table header we give name to each cell) Eg: welcome letter 2. Now this cell when copied and pasted on any other document like word, or writing email it paste a complete pre designed template eg: letter template 3. When you double click this cell it lets you edit your letter template Sir i am one of your subscriber i have seen numbers of your videos that helps me every time. If you could please solve this i will be very thankfull
You have no idea how long I've been trying to find or even create a simple calendar template in sheet which doesn't involve Appscript. Thank you so much.
:)
@@ExcelGoogleSheets how do you input the holiday being celebrated besides it being highlighted on the said date?
I've been struggling for more than 4 hours trying to mark events dates in the calendar, and you just saved me time with this clear and perfect tutorial, I must say that I learnt most of Google sheets formulas from your channel, thank you so much, you have a great method of teaching and make those formulas look simple :)
Man! Once again you bring solid gold to the sheets realms!
Thank you for your great work and thank you for teaching us how to do it as well!
Appreciate cha!
genius! you've explained it in the best way possible. thanks a ton 😍
Loving the calendar. Many thanks for all your videos on here. They have been solid as far as explanations go.
Thank you so much!!! 🙏🏾 I would have never been able to figure out how to automatically populate all the details. 💕💕
Father of all sheets. Thank you so so so much. I was looking for this just last week.
Glad it was helpful!
i am not getting the right words to express my gratitude... so i just say thank you very much... u r a life saver..
I couldn't remember how to do this to save my life. Thank you.
Really great video! Just what I needed. I would also like to be able to select the date in the heading to get the correct month. Thanks so much for a clear explanation and example.
Genius, you earned my respect, you solved my life, keep going like this, thanks so mucho for helping the community
This calendar was so helpful for my company, tysm.
Wow, Wow, Wow, Wow!!!! Thank you sooooo very much Sir!!! Exactly what I need! Yes was able to make it work from A to Z ... after 5 hours! So thankful!
Thank you very much ❤❤🎉 this really really helps a lot...
But I'm facing some struggle.. I've made the conditional formatting to the first day and the cell under it, as you have explained, BUT when I go copy and paste that to all the rest I get them allll at that color.. instead of only for the days aren't included at the month...😅😢 how can I solve that..
Bear in mind I do special paste& format only ..
I don't know why..
I learned so much from your videos. Thank you very much for effort. This should have been taught at school.
You got marvelous contents across each and every video. Thank you SO much!
:)
Thank you. :) Could you also teach how to put a strikethrough or make text gray for dates that are completed? :)
Always a pleasure to see content from your side. THANK YOU, SIR!
Thanks!
This video was so helpful! I was wondering how would I be able to color code different events????
PERFECT!!! All I needed and coudn't find a good explanation!! Thanks for that.
Thank you very much, I've been following you since last month and your videos greatly help me on my work
This is a great tool. Thanks so much for the lesson and for creating it.
This is AMAZING and extremely HELPFUL!! Thank you so much!
Thank you so much! Is there a way to have different font colors for different events within the same cell/day?
Great video, thank you!
Thank you! In the "Add Holiday" portion, can you add to the formula to include a column b with the holiday discription that will display the holiday name in the same cell?
Yes please trying to do this too!
Hello, is there a way that the events on the calendar becomes color coded depending on who adds the event? We are using this as a shared family calendar.
I was going to ask this exact question - did you get an answer or figure out a solution?
I found it a good idea, for me, to include fields to remind me of bills to pay, or for my business, when I have money (that should be) coming in. Basically, and bills-payable, or bills-receivable, calendar all in one place.
This is great! But on the details part, I'm only getting an error saying "No matches are found in Filter evaluation". How do I go about it? Thanks!
Hey, This is so amazing, but one question: How do you slow the problem with transfering it to a monday to sunday based calendar? (Not sunday to saturday). I espescially mean with the month june 2025 where june 1 is disappering. It has something to do with the "weekday()" command, which sets sunday as value 1 and saturday as value 7. I want sunday to have value 7 and saturday as value 6. :)
I've been kind of making my own calendar but not like this to help me know which day I work with 2 jobs. is there a way to highlight am time in one color and pm in another in the formula?
This is soooooo wonderful!! Can't thank you enough.... Thank you, Thank you!!
Hi there thanks for this! I was wondering if you had a solution for tasks that are reoccurring?
Hey! Thank you so much for all this information, I want to ask, I'm using this calendar to manage all the events for the company I'm working for, and they asked me if I could highlight in one date 2 different events, so they can difference which area is in charge of those events by the color of the highlight
Is this possible using a formula?
Thank you in advance.
do you think there is a way to make an event last for multiple days and still show up on the calendar?
This was a great video, thank you so much!!
OMG... thank you so much 😭😭
You add excellent videos. Keep it up!.
Question: is there a way to have all months in one single sheet?
Sure, you can do all of them on the same sheet.
This was very hepful. I ran into an odd issue. I created an event for October 30, but It's only populating in the shadowed October 30 Day in the November Calendar. Do you know what I might've done wrong? The issue only seems to exist in the October calendar.
This is amazing!! BEST video on how to work with calendar function! Is there a way to create a filter for a range of dates?? I want to indicate when certain people will be out of our office and I know I can add EACH date and have it show up - but I imagine I would have 2 columns (start date, end date) and I would want to assign a custom color to each "boss". That seems like it should be do-able, but not sure where to start?
Learn a ton about advanced conditional formatting and logical tests & you should be able to do it.
Big Mahalo, for taking the time on making this amazing video!
this is brilliant and I have got it to work correctly. Now I need to take it a step further and do this with a weekly schedule, so that the correct event goes into the correct time slot on the correct day - how can I do that?
FIRST OF ALL: WONDERFUL VIDEO, it has been extremely helpful and I learned a lot!!
I do have a question;
When the text is joined, by any chance is there a feature that can color text to code different events in the calendar?
For instance, I'm putting my bills in the calendar with the list "Details" & "Details Sorted"; however, I would like to be able to color code the bills on my calendar so I can see (blue) wording or (blue) background for all of my credit card payments and (green) for all of my insurance payments, (orange) for all of my subscriptions, ETC....
Did you figure it out?
Moço, muito obrigada! estou a tanto tempo procurando por algo assim, você me salvou hahaha Obrigada mesmo!!!
This is great but when I don't have anything schedulled for that particular day the filter comes up with a N#/A error, anyway to fix this?
Thanks man! Great help!
👍
Thanks now i know indirect and join formula❤️
You are a wizard! Thank you!!
👍
Well done bro great
This was so helpful!! Thank you
Hey Its really helpful, thanks allot for such a great video
Nice calendar, and I did almost verything you recommended, but I don't know why when I added another condition to the filter, my previous working data disappeared. I wanted to use another column that had a word in it. Some rows had the work bank, others had loan, others had interest, and sometimes they had the same date. But when I set it up for the word "loan", the detail info I wanted to show went away. What am I doing wrong?
Thanks.
AMAZING
This is a great tutorial. I am however, struggling with the "Add Details" part of this. I was able to get it to work on one spreadsheet. Then I copied and pasted the formula to another spreadsheet and it did not work in the second one. Any thoughts on why that might be?
Hello, I have difficulty adding a new line to the Join events step. Since my iPad has no Alt+enter function key. Could you please help me any other way to make all the events in order?
is there a way to input data that has repetition or let’s sa it automatically calculates the position like every first friday of the every month. is there such a formula?
thanks
You are God of Google Sheets
thank you so much for this tutorial! it works really great thanks buddy!
:)
Great! Is there a way to show only certain data on calendar using filters details sheet?
very useful, thank you
Hi,
How should we proceed to start the week from Monday?
Would you be able to tell me how I could add a date range into the calendar? For example, if I have an event that would be multiple days how could I show that on the calendar?
Thank you for this tutorial.
🙂
Excellent
I followed everything in this video to the T. I'm having issues seeing the event description on the same day as a holiday. Please let me know how I can resolve this.
thanks a lot sir
thanks for the video, i have problem with 1 January 2023, its not shown first date of january 2023 on sunday and every first date begining on sunday
Great video - I had an idea to make a running total, solvency type sheet for a bank account balance that would look like this. Mainly to keep track of when things were coming and going from a checking account to be sure it doesn't pass 0. Particularly with withdrawals that will always be on the same day of the month, and biweekly paychecks. The details tab in this video seems like a great way to do this if you add some running total functionality.
thank you
Hello,
At ERP Launchpad, we can help you automate your business according to your custom requirements by creating a cloud-based web portal and creating some extremely user-friendly modules for your business.
If this is fine with you, do give us a reply.
I'm watching this and I think it's amazing. can I use a pivot table to get the data? Thanks so much man 😊👍
Sure, if you use the data tab where the source is formatted right.
Excellent video! Super clear instructions.
Hello. Could you help me, if i need put events for several days, so i need start and end date. and what if there are several departments could add events. if u have some other videos?
How can I create a calendar of 2 days only? It's for a school, since every group studies only twice a week. I want to create one that has for instance just every Friday and Saturday.
Fantastic video thank you!!!!! :)
Great video, but when I insert hyperlinks in sheet details, back to calendar its not show the link to click it, how can I do it ?
How can make it without the time column, I mean only for C column depends on A column in the calender?
One of the master piece 🌻
👍🏻 Brilliant as usual. Thanks!
Thanks!
Very indeed , worth watching
Great and will be greater if you could add dynamic dropdown list of desired month so data would be displayed in the same sheet instead of many sheets.
You should be able to just add data validation on that cell and you are done.
@@ExcelGoogleSheets Thank you. One more question please. If there are let’s say more details of tasks of a specific day, any idea to display details of that day in a big space under the calendar table or in a separated sheet once I click on that desired day 🤔.
Thank you🙏
How do you add more rows between weeks and keep the formatting?
I'm completely lost on very last step where just copy the formula and paste it to all cells. it will not automatically populate the task on that day, and when i tried to paste it, the border line disappears too. couldn't figure out why
Thank you very much for this great video!
I am trying to insert holidays that start at a date, and end at another date, so I replaced "cell = date" to "AND(cell=CellRange2)", but something isn't working; is there any restriction for using AND with Cell Ranges?
Yes. Watch this for more info ua-cam.com/video/NM5-bAUP29U/v-deo.html
@@ExcelGoogleSheets Giving a solution is very nice, but inspiring someone to find one is way better, thank you for being inspirational!
@@amirka25 Did you find it, I don't seem to get the new video in this context
@@Zzjul Yes, I did...
Did you manage to solve the problem you're facing? I'm ready to help if needed, I'm available on LinkedIn if you like to connect...
how do you input the holiday being celebrated besides it being highlighted on the said date?
Awesome can you add week number of the year, as reference?
i would like to ask, why mine isnt correct. the year which shows is 1899 while the year which i want is 2023. thank you in advance
Is there a way to make a running calendar for the entire year on just one sheet?
any way you can add information to a cell without affecting the formula? Just like a real calendar?
How you can maintain details about January only in this month? The reason is because when a select february, details appear also in this month as a error.
Quality content as usual. Great Job 👍
Thank You!
i dont understand when i used the function of weekday my date started to 1900 year instead the current year (2023). could you help how to fix that?
First time trying this out. I keep getting stuck with an error while building the formula (either value error or won't display correctly). My use case is a bit unique though with an editorial calendar of 20+ posts a day. And I need to build upon it further with dropdown menus as well (if 'dropdown option a' then 'parse to calendar', if 'dropdown option b' then 'don't parse to calendar' kind of thing). Only been at it two days but so far I'm loving the journey and I'm determined!
Template is in the description.
Awesome content! Edit: I wasn't looking for it when suddenly your tip about custom formula caught my attention. Is it possible to make a video only teaching custom formulas for conditional format and custom formula for pivot tables? I always get stucked whenever I've got to use something like that. Custom formula is mayhen for me.
I already have video about both on the channel.
@@ExcelGoogleSheets I'll take a look on your old videos. What are the titles?
ua-cam.com/users/LearnGoogleSpreadsheetssearch?query=conditional%20formatting%20advanced
ua-cam.com/users/LearnGoogleSpreadsheetssearch?query=calculated%20fields%20pivot
@@ExcelGoogleSheets Man, from the deep of my heart, you're the humblest and kindest youtuber I've ever met. Thanks again.
Hello,
At ERP Launchpad, we can help you automate your business according to your custom requirements by creating a cloud-based web portal and creating some extremely user-friendly modules for your business.
If this is fine with you, do give us a reply.
How can I add event information when the event information is on the same page as the calendar?
Very useful. Thank you :)
Glad to hear that!
Thank you very much :)
:)
I can't get past the first step, it keeps setting the date to 12/30/1899 even though I am clicking the first cell. HELP!!
Thankyou!
:)
I LOVE YOU!!!
Thanks..
Hi! I didnt find any youtube video that can answer my problem
1. A cell that has name (like in table header we give name to each cell) Eg: welcome letter
2. Now this cell when copied and pasted on any other document like word, or writing email it paste a complete pre designed template eg: letter template
3. When you double click this cell it lets you edit your letter template
Sir i am one of your subscriber i have seen numbers of your videos that helps me every time. If you could please solve this i will be very thankfull