历史版本1 :本周日期获取 返回文档
编辑时间: 内容长度:图片数:目录数: 修改原因:

简单的公式计算，在论坛中总是有人来问如果获取本周、上周、下周的第一天和本周的最后一天，此篇文档诞生勒；

1、国际惯例，效果图


222

2、公式运用

"当前日期:" + today()

国内：

"本周第一天" + DATEDELTA(TODAY(), if(tointeger(WEEKDAY(TODAY())) = 0, -6, 0 - WEEKDAY(TODAY()) + 1)) "本周最后一天" + DATEDELTA(TODAY(), if(tointeger(WEEKDAY(TODAY())) = 0, 0, 7 - WEEKDAY(TODAY()))) "上周第一天" + DATEDELTA(DATEDELTA(TODAY(), -7), if(tointeger(WEEKDAY(DATEDELTA(TODAY(), -7))) = 0, -6, 0 - WEEKDAY(DATEDELTA(TODAY(), -7)))) "上周最后一天" + DATEDELTA(DATEDELTA(TODAY(), -7), if(tointeger(WEEKDAY(DATEDELTA(TODAY(), -7))) = 0, 0, 7 - WEEKDAY(DATEDELTA(TODAY(), -7)))) "下周第一天" + DATEDELTA(DATEDELTA(TODAY(), 7), if(tointeger(WEEKDAY(DATEDELTA(TODAY(), 7))) = 0, -6, 0 - WEEKDAY(DATEDELTA(TODAY(), 7)))) "下周最后一天" + DATEDELTA(DATEDELTA(TODAY(), 7), if(tointeger(WEEKDAY(DATEDELTA(TODAY(), 7))) = 0, 0, 7 - WEEKDAY(DATEDELTA(TODAY(), 7))))

国外：

"本周第一天" + DATEDELTA(TODAY(), if(tointeger(WEEKDAY(TODAY())) = 0, 0, 0 - WEEKDAY(TODAY()))) "本周最后一天" + DATEDELTA(today(), if(tointeger(WEEKDAY(today())) = 0, 6, 6 - WEEKDAY(today()))) "上周第一天" + DATEDELTA(DATEDELTA(TODAY(), -7), if(tointeger(WEEKDAY(DATEDELTA(TODAY(), -7))) = 0, 0, 0 - WEEKDAY(DATEDELTA(TODAY(), -7)))) "上周最后一天" + DATEDELTA(DATEDELTA(TODAY(), -7), if(tointeger(WEEKDAY(DATEDELTA(TODAY(), -7))) = 0, 6, 6 - WEEKDAY(DATEDELTA(TODAY(), -7)))) "下周第一天" + DATEDELTA(DATEDELTA(TODAY(), 7), if(tointeger(WEEKDAY(DATEDELTA(TODAY(), 7))) = 0, 0, 0 - WEEKDAY(DATEDELTA(TODAY(), 7)))) "下周最后一天" + DATEDELTA(DATEDELTA(TODAY(), 7), if(tointeger(WEEKDAY(DATEDELTA(TODAY(), 7))) = 0, 6, 6 - WEEKDAY(DATEDELTA(TODAY(), 7))))