Hi Eamonn, I hope I can get your help on this. I am creating the calendar for 2025, and January 1st starts on Wednesday this year. However, when I try your formula for the January 2nd cell, I am still getting the date 1st on Thursday on my template. Is there anything I am doing wrong with the formula? I tried my luck several times, but I still the same error.
It may have to do with the optional [type] parameter on the weekday function. By default, Sunday will equal 1 and that's how I setup my example project. But if you have yours setup to start with Monday, for instance, you need to add that type = 2. And I'm simply talking about the structure of your calendar in the spreadsheet - whether the first day on the leftmost column is Sunday or Monday etc.
Hello Eamonn, thank you so much for this. I keep getting the False response after using the first Weekday function to get the exact day of the week, could you confirm what I'm doing wrongly. Thank you.
I bet you left out the optional empty quotes for the IF statement. If you don't have empty quotes, then it defaults to simply displaying FALSE. Here's the formula I used: =IF(WEEKDAY(B3)=B4,B3,"")
My 7th day always turns back to 01 instead of 07 . function looks correct but it wont follow the command and makes my 7th day always back to 01 from 06.
Thank you so much for this, how about i wanted to have data validation for the months, instead of creating a new month each i want to be able to select the month on a drop_down menu and maybe have the year on a drop_down. now the calendar auto changes depending on the month and selected. any tip
Hey there, yes, you can do this...Say you add a couple rows at the top and have the year in C1 and the month in C2...you can put this formula in B3 so it updates that first month to the month and year you specify: =DATE(C1,MONTH(C2&1),1)... I may make another video on this since I like your approach better than the full year laid out. If you do this, just delete all the rows below it
⭐⭐Grab the FREE demo sheet here: www.gotsheet.xyz/c/calendar-in-google-sheet
Hi Eamonn, I hope I can get your help on this. I am creating the calendar for 2025, and January 1st starts on Wednesday this year. However, when I try your formula for the January 2nd cell, I am still getting the date 1st on Thursday on my template. Is there anything I am doing wrong with the formula? I tried my luck several times, but I still the same error.
It may have to do with the optional [type] parameter on the weekday function. By default, Sunday will equal 1 and that's how I setup my example project. But if you have yours setup to start with Monday, for instance, you need to add that type = 2. And I'm simply talking about the structure of your calendar in the spreadsheet - whether the first day on the leftmost column is Sunday or Monday etc.
Well done and thank you!
You're welcome!
Thank you so much for providing this in google sheets! Can't wait to use it!
You're welcome!
Most Underrated Google Sheets dynamic calendar explanation ever! Best video, it's the most dynamic calendar ❤
Thanks!! 😊
Hello Eamonn, thank you so much for this.
I keep getting the False response after using the first Weekday function to get the exact day of the week, could you confirm what I'm doing wrongly.
Thank you.
I bet you left out the optional empty quotes for the IF statement. If you don't have empty quotes, then it defaults to simply displaying FALSE. Here's the formula I used: =IF(WEEKDAY(B3)=B4,B3,"")
This is amazing!! Thank you
You're welcome!!
My 7th day always turns back to 01 instead of 07 . function looks correct but it wont follow the command and makes my 7th day always back to 01 from 06.
Thank you so much for this, how about i wanted to have data validation for the months, instead of creating a new month each i want to be able to select the month on a drop_down menu and maybe have the year on a drop_down. now the calendar auto changes depending on the month and selected. any tip
Hey there, yes, you can do this...Say you add a couple rows at the top and have the year in C1 and the month in C2...you can put this formula in B3 so it updates that first month to the month and year you specify: =DATE(C1,MONTH(C2&1),1)...
I may make another video on this since I like your approach better than the full year laid out.
If you do this, just delete all the rows below it
@@EamonnCottrell Thank you would try it out. while anticipating your video.
@@Ezee-z9jcheck it out here: Dynamic Monthly Calendar in a Spreadsheet
ua-cam.com/video/ki0kXnx9SSU/v-deo.html
@@Ezee-z9j Here's the new one:
ua-cam.com/video/ki0kXnx9SSU/v-deo.html