求助，麻烦问下2022/12/7--2023/6/6这样的数据有一列怎么算几个月呀

lws

变通一下，把DATEDIF()第二个参+1。

浮生若梦~~~

Mercur1o丶 发表于 2023-10-31 22:05
嗯嗯 是的。所以我对的眼花缭乱。

=IF(DATEDIF(SUBSTITUTE(LEFT(A2,FIND("-",A2)-1),".","/"),SUBSTITUTE(MID(A2,FIND("-",A2)+1,19),".","/"),"md")=30,TEXT(DATEDIF(SUBSTITUTE(LEFT(A2,FIND("-",A2)-1),".","/"),SUBSTITUTE(MID(A2,FIND("-",A2)+1,19),".","/"),"ym")+1,"[>0]0个月;"),IF(DATEDIF(SUBSTITUTE(LEFT(A2,FIND("-",A2)-1),".","/"),SUBSTITUTE(MID(A2,FIND("-",A2)+1,19),".","/"),"md")=0,TEXT(DATEDIF(SUBSTITUTE(LEFT(A2,FIND("-",A2)-1),".","/"),SUBSTITUTE(MID(A2,FIND("-",A2)+1,19),".","/"),"ym"),"[>0]0个月;")&"1天",TEXT(DATEDIF(SUBSTITUTE(LEFT(A2,FIND("-",A2)-1),".","/"),SUBSTITUTE(MID(A2,FIND("-",A2)+1,19),".","/"),"ym"),"[>0]0个月;")&TEXT(DATEDIF(SUBSTITUTE(LEFT(A2,FIND("-",A2)-1),".","/"),SUBSTITUTE(MID(A2,FIND("-",A2)+1,19),".","/"),"md"),"[>0]0天;")))

浮生若梦~~~

Mercur1o丶 发表于 2023-10-31 22:05
嗯嗯 是的。所以我对的眼花缭乱。

=IF(DATEDIF(LEFT(A33,FIND("-",A33)-1),MID(A33,FIND("-",A33)+2,19),"md")=30,TEXT(DATEDIF(LEFT(A33,FIND("-",A33)-1),MID(A33,FIND("-",A33)+2,19),"ym")+1,"[>0]0个月;"),IF(DATEDIF(LEFT(A33,FIND("-",A33)-1),MID(A33,FIND("-",A33)+2,19),"md")=0,TEXT(DATEDIF(LEFT(A33,FIND("-",A33)-1),MID(A33,FIND("-",A33)+2,19),"ym"),"[>0]0个月;")&"1天",TEXT(DATEDIF(LEFT(A33,FIND("-",A33)-1),MID(A33,FIND("-",A33)+2,19),"ym"),"[>0]0个月;")&TEXT(DATEDIF(LEFT(A33,FIND("-",A33)-1),MID(A33,FIND("-",A33)+2,19),"md"),"[>0]0天;")))

橒♂蝣

=NPV(-2,--TEXT(SUBSTITUTE(TEXTSPLIT(M11,"-"),".","/"),"yyyy/mm/dd"))

mjm04

高版本 或 WPS 可用

=REDUCE(0,SUBSTITUTE(REGEXP(A2,"[^-]+"),".","/")*1,LAMBDA(a,b,b-a))

jivy1212

1. =NPV(-2,DATEDIF(,IMREAL(IMDIV(SUBSTITUTE(A33,"--","-")&"i",{1,"-i"}))+{0,1},"m"))

复制代码

显示月成不

1786024734

1. =LET(x,SUBSTITUTE(SUBSTITUTE(A2,".","/"),"-","  "),CONCAT(TEXT(DATEDIF(LEFT(x,10)+0,TRIM(RIGHT(x,10))+1,{"M","MD"}),{"0个月","0天"}&";;;")))

复制代码