Home » Crypto Trading Guide » Get Date from Week Number in Google Sheets

Get Date from Week Number in Google Sheets

Sophia Al-Mansoor • • 3 min read
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

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

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

Sophia Al-Mansoor

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