Excel is one of the most popular tools to work with data with more than 400 different functions. Some of them are great to calculate ISO week number in Excel, but ISO year is not so easy.
ISO week number in Excel
You can calculate the ISO week number by using the function ISOWEEKNUM or WEEKNUM. In the WEEKNUM is necessary to use return type argument 21 to calculate week number by ISO standard.
=ISOWEEKNUM(A2) =WEEKNUM(A2;21)
Here you can read more about ISO week numbering.
ISO year in Excel
ISO year is necessary if you have multiple years and want to group data using ISO week number. Some of the dates at the end or beginning of the year might belong to another year.
If you already calculated the ISO week number, then it is easy to do mathematically like this.
Further learning
Here is an easy Excel trick that you can use to copy Excel chart formatting from one to another.
Are you great at Excel and want to try something new? Take a look at how you can use Excel knowledge to learn R.
Leave a Reply