此公式如何四舍五入?=(TODAY()-DATE(YEAR(NOW()),MONTH(A1),DAY(A1)))/365

来源：学生作业帮编辑：搜狗做题网作业帮分类：综合作业时间：2024/05/09 08:50:00

此公式如何四舍五入?
=(TODAY()-DATE(YEAR(NOW()),MONTH(A1),DAY(A1)))/365*LOOKUP(INT(B1/12),{0,1,10,20},{0,5,10,15})
这个公式计算出来的数字需要四舍五入

=ROUND((TODAY()-DATE(YEAR(NOW()),MONTH(A1),DAY(A1)))/365*LOOKUP(INT(B1/12),{0,1,10,20},{0,5,10,15}),)
再问： =(365-DATE(YEAR(NOW()),12,31)+DATE(YEAR(NOW()),MONTH(D3),DAY(D3)))/365*LOOKUP(INT(E3/12),{0,1,10,20},{0,5,10,15})+F3

大神怎么算出来是负数你再重新帮我整一下？
再答：将源数据贴现上图片上来

此公式如何四舍五入?=(TODAY()-DATE(YEAR(NOW()),MONTH(A1),DAY(A1)))/365 谁能帮忙改个公式 =ABS(DATE(YEAR(TODAY()),MONTH($G3),DAY($G3))-TODAY( =ABS(DATE(YEAR(TODAY()),MONTH($B2),DAY($B2))-TODAY()) =DAY(TODAY())/DAY(DATE(YEAR(TODAY()),MONTH(TODAY())+1,0)) IF(AND(MONTH(A1)>=9,DAY(A1)>=1),DATEDIF(A1,TODAY(),"y")-1,DA PHP：$week = date('w',strtotime($year.'-'.$month.'-'.$day)); date(year,month,day),Excel中用DATE这个函数,如何day这个参数为0表示什么意思?month 公式“=(YEAR(TODAY())-YEAR(B8))*12+(MONTH(TODAY())-MONTH(B8))-1 date(year,month,day) 取消year有什么办法吗? excel中的公式"=TEXT(DATE(LEFT(A1,4),MID(A1,6,2),RIGHT(A1,3)),"yy IF(MONTH(DATE($A$1,$D$1,COLUMN(A1)))=$D$1,DATE($A$1,$D$1,COL excel 表格 T9 =DATE(YEAR(TODAY()),MONTH(TODAY()),1) 是这个月的6月1号,