Get Date from Week Number in Google Sheets

Sophia Al-Mansoor
Sophia Al-Mansoor
• • 3 min read

If I Have Week 7 in 2017 What Week Date Is the Monday in That Week in Google Sheets? 5 Answers =Date(B9,1,1)-Weekday(Date(B9,1,1),3)+7*(Weekday(Date(B9,1,1),3)>...

Get Date from Week Number in Google Sheets

If I have week 7 in 2017 what week date is the Monday in that week in Google Sheets?

5 Answers 

=DATE(B9,1,1)-WEEKDAY(DATE(B9,1,1),3)+7*(WEEKDAY(DATE(B9,1,1),3)>3)+7*(A9-1)

is the least complicated formula I know which works for week numbers in Sweden (i.e. Monday first day of week, ISO rules for what is week 1).

3

Must Read

Short answer (A1==Week, B1==Year):

=DATE(B1;1;1)+((A1-1)*7)-WEEKDAY(DATE(B1;1;1);3)
Sophia Al-Mansoor

Sophia Al-Mansoor

Global Business & E-Commerce Reporter
Linkedin Twitter

Sophia analyzes international trade, startup ecosystems, retail transformation, and supply chain logistics for modern digital publications.