WEEK("2024-01-01") = 53 是bug?
赞 0 踩 0 2024-02-03 16:00
same bug:WEEK("2024/01/01") = 53
赞 0 踩 0 2024-02-03 16:08
11月30号,往前推3个月,怎么取到8月30号?
赞 0 踩 0 2024-01-15 11:37
这个获取上月函数date(year(today()),MONTH(today())-1,day(today())),将month计算的-1改为-3就是往前推3个月
赞 0 踩 0 2024-04-11 14:47
您好,上上月公式,=date(year(today()),MONTH(today())-2,day(today())),不太完善,跨年无法计算,应为monthdelta(today(),-2);上月公式=date(year(today()),MONTH(today())-1,day(today())),应为monthdelta(today(),-1);去年同期上月=date(year(today(
赞 1 踩 0 2023-10-24 14:26
去年同期上月=date(year(today())-1,MONTH(today())-1,day(today()))应为=monthdelta(YEARDELTA(today(),-1),-1)
赞 0 踩 0 2023-10-24 14:27
无法将数据包中的日期进行过滤是什么操作 函数选取了之后无法选中表格
赞 0 踩 0 2023-10-12 17:26
如何返回一列日期中最早的一天
赞 3 踩 0 2023-07-04 08:54
min
赞 0 踩 0 2024-01-15 14:09
29 评论
WEEK("2024-01-01") = 53 是bug?
赞 0 踩 0 2024-02-03 16:00
same bug:WEEK("2024/01/01") = 53
赞 0 踩 0 2024-02-03 16:08
11月30号,往前推3个月,怎么取到8月30号?
赞 0 踩 0 2024-01-15 11:37
这个获取上月函数date(year(today()),MONTH(today())-1,day(today())),将month计算的-1改为-3就是往前推3个月
赞 0 踩 0 2024-04-11 14:47
您好,上上月公式,=date(year(today()),MONTH(today())-2,day(today())),不太完善,跨年无法计算,应为monthdelta(today(),-2);上月公式=date(year(today()),MONTH(today())-1,day(today())),应为monthdelta(today(),-1);去年同期上月=date(year(today(
赞 1 踩 0 2023-10-24 14:26
去年同期上月=date(year(today())-1,MONTH(today())-1,day(today()))应为=monthdelta(YEARDELTA(today(),-1),-1)
赞 0 踩 0 2023-10-24 14:27
无法将数据包中的日期进行过滤是什么操作 函数选取了之后无法选中表格
赞 0 踩 0 2023-10-12 17:26
如何返回一列日期中最早的一天
赞 3 踩 0 2023-07-04 08:54
min
赞 0 踩 0 2024-01-15 14:09