How to Create a Dynamic Monthly Calendar in Google Sheets - Template Provided

Описание к видео How to Create a Dynamic Monthly Calendar in Google Sheets - Template Provided

In this video, I demonstrate how to create a dynamic monthly calendar which updates depending on the month/year entered as the title.

To skip the tutorial and access a working template you can copy to your own document, use the following link (PLEASE don't ask for access edit access -- most users should have READ access and you can MAKE A COPY which you can edit -- instructions provided herein. Some domains such as verizonwireless.com may block your access, and I can't help you there as it's out of my hands):
https://docs.google.com/spreadsheets/...

Hopefully this will be useful for others. It's my first attempt at a video for public consumption, so I haven't tried to do any fancy editing or anything.

As is often the case with Google Sheets and other spreadsheets, there might be different/better ways to do a lot of the things I did, in retrospect; the way I accomplished the task at hand just happened to be the approach I took at the time. For example, any use of =IF(ABS(cell)>0,true,false) could nicely be replaced with =IF(ISNUMBER(cell),true,false) which would've made more sense.

Комментарии

Информация по комментариям в разработке