历史版本6 :本周日期获取 返回文档
编辑时间:
内容长度:图片数:目录数:
修改原因:
1. 描述编辑
在报表设计中，经常需要获取本周、上周、下周的第一天和最后一天，那么该如何获取呢？
2. 公式编辑
当前日期：
"当前日期:" + today()
2.1 国内
本周第一天：
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))+1))
上周最后一天：
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))+1))
下周最后一天：
DATEDELTA(DATEDELTA(TODAY(), 7), if(tointeger(WEEKDAY(DATEDELTA(TODAY(), 7))) = 0, 0, 7 - WEEKDAY(DATEDELTA(TODAY(), 7))))
2.2 国外
本周第一天：
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))))
具体事例可查看周报