如何在Excel中将日历周转换为日期？

问题描述：

我有一个星期数字和一年，并且想在Microsoft Excel中计算该特定星期的星期一的日期。

I have a week number and a year, and would like to calculate the date of the Monday for that specific week in Microsoft Excel.

Year   Week   Date (Monday)
2012   1      January 2, 2012
2013   16     April 15, 2013
2014   42     October 13, 2014

我可以使用什么公式将日历周转换为特定日期？

What formula can I use to convert a calendar week to a specific date?

答

对于ISO周编号，您可以使用此公式获取星期一

For ISO week numbers you can use this formula to get the Monday

= DATE（A2,1， -2）-WEEKDAY（DATE（A2,1,3））+ B2 * 7

假设A2中的年份和B2中的星期数

assuming year in A2 and week number in B2

it's the same as my answer here https://stackoverflow.com/a/10855872/1124287