=DAY(TODAY())/DAY(DATE(YEAR(TODAY()),MONTH(TODAY())+1,0))
问题描述:
=DAY(TODAY())/DAY(DATE(YEAR(TODAY()),MONTH(TODAY())+1,0))
谁能帮忙解答下这个excel中的时间占比公式每一部分的具体含义呢?后面看不太明白
答
YEAR(TODAY())——今天对应的年份MONTH(TODAY())+1——今天对应月份+1DATE(YEAR(TODAY()),MONTH(TODAY())+1,0)——合起来就是今天所在月份的最后一天,因为DATE(YEAR(TODAY()),MONTH(TODAY())+1,1)对应的是今天所在月...