=DAY(TODAY())/DAY(DATE(YEAR(TODAY()),MONTH(TODAY())+1,0))谁能帮忙解答下这_其他解答

=DAY(TODAY())/DAY(DATE(YEAR(TODAY()),MONTH(TODAY())+1,0))
谁能帮忙解答下这个excel中的时间占比公式每一部分的具体含义呢?后面看不太明白

人气：453 ℃　时间：2020-10-02 00:16:58

解答

YEAR(TODAY())——今天对应的年份MONTH(TODAY())+1——今天对应月份+1DATE(YEAR(TODAY()),MONTH(TODAY())+1,0)——合起来就是今天所在月份的最后一天,因为DATE(YEAR(TODAY()),MONTH(TODAY())+1,1)对应的是今天所在月...