LibreOffice Calc电子表格提供函数ISOWEEKNUM以返回指定日期的标准ISO 8601 week number .
我想要相反的 .
➠给定标准周数,给我那个星期的第一天(星期一)的日期 .
传递整数是可以接受的 . 如果能够以标准格式传递字符串也很好 .
像这样:
DATE_OF_ISOWEEKNUM( 2017 , 42 ) ➝ date of Monday of week 42 in week-based year 2017
DATE_OF_ISOWEEKNUM( "2017-W42" ) ➝ date of Monday of week 42 in week-based year 2017
理想情况下,我可以在周一至周日通过1-7号来指定我想要约会的星期几 . 像这样的东西:
DATE_OF_ISOWEEKNUM( 2017 , 42 , 1 ) ➝ date of Monday of week 42 in week-based year 2017
DATE_OF_ISOWEEKNUM( "2017-W42-1" ) ➝ date of Monday of week 42 in week-based year 2017
DATE_OF_ISOWEEKNUM( 2017 , 42 , 7 ) ➝ as above, but Sunday
DATE_OF_ISOWEEKNUM( "2017-W42-7" ) ➝ as above, but Sunday
1 回答
例:
式:
计算一年中的日期(周数* 7) .
将星期一更正为工作日 .
如果一年中的第一天是第一个ISO周数,则更正前7天 .