Week numbers in LibreOffic Calc


I use week numbers for all sorts of things. It gives me more granularity than a month, and they’re more accurate for certain use cases. For example, people assume a month has four weeks, but 48 leaves us four weeks short of the 52 weeks in a year. Renters and mortgage payers know all to well the fun of realising a specific month has three payments, not two.

(As an aside, that’s yet another reason why envelope budgeting is great. Before I required any tenancy agreement I signed to be paid monthly instead, I’d average out the cost of rent over twelve months and keep that extra in the “rent” envelope, so I’d never be surprised when those triple payment months appeared).

That uncharacteristically verbose introduction aside, this is how you can calculate the current week number from an epoch or existing date:

=WEEKNUM(A1; 21)

I was confused why this wasn’t returning what I expected when I didn’t include the second parameter, but WeekNumber.com explained:

21 is a code that identifies ISO week numbers among other week numbering schemes.


Author bio and support


Ruben Schade is a technical writer and infrastructure architect in Sydney, Australia who refers to himself in the third person. Hi!

The site is powered by Hugo, FreeBSD, and OpenZFS on OrionVM, everyone’s favourite bespoke cloud infrastructure provider.

If you found this post helpful or entertaining, you can shout me a coffee or send a comment. Thanks ☺️.