1.时间
获取闰年和平年:
IF (YEAR([日期])%4=0 AND YEAR([日期])%100!=0) OR (YEAR([日期])%100=0 AND YEAR([日期])%400=0)
THEN 366
ELSE 365
END
获取月份天数:
IF MONTH([日期])=2 THEN
IF (YEAR([日期])%4=0 AND YEAR([日期])%100!=0) OR (YEAR([日期])%100=0 AND YEAR([日期])%400=0) THEN 29 ELSE 28 END ELSE
IF (MONTH([日期])=4 OR MONTH([日期])=6 OR MONTH([日期])=9 OR MONTH([日期])=11) THEN 30 ELSE 31 END
END
2.AVG
AVG(IF A THEN B END)*(DATE(#2018-12-31#)-MAX([日期]))+SUM(IF YEAR([日期])=2018 THEN B END)