https://www.marketersgo.com/marketing/google-sheets/202005/googlesheet-google-excel-ganttchart/
2021年1月26日
Google Sheet - Week number to Date
=DATE(A1, 1, -3 + 7 * B1 - WEEKDAY(DATE(A1, 1, 4), 2) + 1)
A1: Year
B1: Week number
訂閱：
文章 (Atom)
https://www.marketersgo.com/marketing/google-sheets/202005/googlesheet-google-excel-ganttchart/
=DATE(A1, 1, -3 + 7 * B1 - WEEKDAY(DATE(A1, 1, 4), 2) + 1)
A1: Year
B1: Week number