web analytics

Spreadsheets!

I don’t work Wednesdays. This morning over a leisurely coffee, I thought I’d download a free calendar from the internet to do some scheduling stuff.

But I didn’t like the look of any of the ones I found, so I decided to download a template and fuss with it.

But none of the templates were laid out exactly the way I wanted (I need the week to start Monday, for example), so I decided to build one from scratch.

I am not good at templates. Fortunately, I’m pretty good at stealing code. I found a calendar tutorial for Libre Office and I was humming along, comprehending stuff fine, until I got to the bit in the picture above.

If you can’t read it, it’s

By knowing the first day of the month we can get the day of the week. In my example it’s a Wednesday. The function that returns the day of week from a date is WEEKDAY. The formula is =WEEKDAY(DATE(G1,MATCH(A1,$Settings.A1:A12,0),1)). You should get a number from 1 to 7.

Yeah, no. Never mind. I pinched it and it worked.

People who understand spreadsheets can make them sing. I don’t think I’m ever going to be that person.

September 8, 2021 — 8:52 pm
Comments: 10