发布网友 发布时间:2022-05-01 09:57
共1个回答
热心网友 时间:2023-04-29 03:05
按你的逻辑结果应该是4.87=ROUND((DAY(DATE(YEAR(A1),MONTH(A1)+1,0))-DAY(A1)+1)/DAY(DATE(YEAR(A1),MONTH(A1)+1,0))+DAY(B1)/DAY(DATE(YEAR(B1),MONTH(B1)+1,0))+MONTH(B1)-MONTH(A1)+IF(MONTH(B1)<MONTH(A1),11,-1),2)