Week numbers in Excel


What's the current Week Number...? How often do yourself this question? Finally a quick answer!

In order to make an accurate planning, you need to have a good overview in the months, weeks and days to come. Often you want to make a planning based on week numbers. However, these week numbers are always hard to find. We fix this and provide you a free solution.

Using this downloadable Excel spreadsheet with all week numbers guarantees you a good overview, which will save you time and efforts in the future. Here you find solutions for coming years:

template preview imageWeek numbers 2018

Week numbers 2018

What's the current Week Number in 2018? Download this Calendar Week numbers 2018 Excel template now!

file format: .xlsxView template


template preview imageWeek numbers 2019

Week numbers 2019

How many weeks are there in 2019? Download this Calendar Week numbers 2019 Excel template now!

file format: .xlsxView template


template preview imageWeek numbers 2020

Week numbers 2020

Do you need a spreadsheet with Week Numbers of 2020? Download this Calendar Week numbers 2020 Excel template now!

file format: .xlsxView template


template preview imageWeek numbers 2021

Week numbers 2021

Do you need a spreadsheet with Week Numbers of 2021? Download this Calendar Week numbers 2021 Excel template now!

file format: .xlsxView template


template preview imageWeek numbers 2022

Week numbers 2022

Are you looking for an overview of all week numbers in 2022? Download this Calendar Week numbers 2022 Excel template now!

file format: .xlsxView template


Please note that there are multiple systems for week numbering, this is the ISO week date standard (ISO-8601), other systems use weeks starting on Sunday (US) or Saturday (Islamic). All weeks are starting on Monday and ending on Sunday. 

The ISO week date system is effectively a leap week calendar system that is part of the ISO 8601 date and time standard issued by the International Organization for Standardization (ISO) since 1988 (last revised in 2004) and, before that, it was defined in ISO (R) 2015 since 1971. It is used (mainly) in government and business for fiscal years, as well as in timekeeping. This was previously known as "Industrial date coding". 

The system specifies a week year atop the Gregorian calendar by defining a notation for ordinal weeks of the year. An ISO week-numbering year (also called ISO year informally) has 52 or 53 full weeks. That is 364 or 371 days instead of the usual 365 or 366 days. The extra week is sometimes referred to as a leap week, although ISO 8601 does not use this term.

Check on our website also the week number templates for years: 2018201920202021 and 2022.

 
 

Author profile

Miriam Horton Miriam Horton

Related templates



The NBA is never just a business. It’s always business. It’s always personal. All good businesses are personal. The best businesses are very personal. | Mark Cuban