Getting the Calendar Week in Google Spreadsheet

I hate Google Docs’s spreadsheet app, ‘Sheets’. It’s a lackluster application compared to anything even remotely recent. Its only selling point is the current IT industry’s addiction to simultaneous editing.

I work more with Sales and Finance than I used to, and I find myself referring to things like Fiscal Calendars, which have some relation to Gregorian calendars apparently, and Calendar Weeks, which do not.

In the fine open source program LibreOffice Calc (and presumably Microsoft Excel) there’s a handy function for this, called WEEKNUM. In Google’s spreadsheet, you need to first parse a date, and then slice it.

I googled this from somewhere, and wound up with the following:

= MID(TEXT(A3,"yyww"), 3, 2)

Where A3 is a date.

Seriously, it sucks.

Leave a Reply

Fill in your details below or click an icon to log in: Logo

You are commenting using your account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s