如何提取出各种日期格式中的月份

orange8765

各位老师，如何提取出各种日期格式中的月份

loirol

=IFNA(REGEXEXTRACT(A3,"\d+(?=月)"),MONTH(A3))&"月"

gadxjyang

=TRIM(IFERROR(MONTH(B3),LEFTB(SUBSTITUTES(A3,{"2024年","/"},),2)))&"月"

袁勇

适合附件目前的情况。

1. =TEXT(LOOKUP(9^9,(SUBSTITUTE(TEXT(A3,"e年m月;;;@"),"/",)&{"","日"})*1),"m月")

复制代码

hcm19522

=IFERROR(-LOOKUP(1,-MID(A3,FIND("月",A3)-{1,2},{1,2})),MONTH(A3))

hxj119

1. =REGEXP(TEXT(A3,"yyyy年m月"),"\d+月")

复制代码

华尔街操盘手

就上传的样本看，没有很多干扰因素，感觉可以放一个全一点的数据源，c3下拉

1. =IFERROR(MONTH(--A3),INDEX(--TEXTSPLIT(A3,{"年","月","年/"}),,2))&"月"

复制代码

祝洪忠-

=REGEXEXTRACT(TEXT(A3,"m月"),"\d+(?=月)")

jivy1212

1. =TEXT(SUBSTITUTE(LEFT(A3,FIND("月",A3&"月")),"/",),"m月")

复制代码

jivy1212

1. =-LOOKUP(,-TEXT(SUBSTITUTE(A3,"/",)&{"日",""},"m"))&"月"

复制代码