如何把日期变成中文

首先要有一个日期字段，然后再有一个字段存放中文值，文本即可。
具体公式如下：
CHOOSE(MID(TEXT($MF(日期)$,"yyyy"),1,1)+1,"○","一","二","三","四","五","六","七","八","九")&CHOOSE(MID(TEXT($MF(日期)$,"yyyy"),2,1)+1,"〇","一","二","三","四","五","六","七","八","九")&CHOOSE(MID(TEXT($MF(日期)$,"yyyy"),3,1)+1,"〇","一","二","三","四","五","六","七","八","九")&CHOOSE(MID(TEXT($MF(日期)$,"yyyy"),4,1)+1,"〇","一","二","三","四","五","六","七","八","九")&"年"&CHOOSE(TEXT($MF(日期)$,"MM")+0,"一","二","三","四","五","六","七","八","九 ","十","十一","十二")&"月"&IF(TEXT($MF(日期)$,"dd")+0< 16,CHOOSE(TEXT($MF(日期)$,"dd")+0,"一","二","三","四","五","六","七","八","九","十","十一","十二"," 十三","十四","十五"),CHOOSE(TEXT($MF(日期)$,"dd")-15,"十六","十七","十八","十九","二十","二十一","二十二","二十三","二十四","二十五","二十六","二十七","二 十八","二十九","三十","三十一"))&"日"

效果图：

:curse::handshake:curse:

:handshake:loveliness::dizzy:

SUBSTITUTE(MID(MFCNUM("0."&TEXT($MF(日期)$,"YYYY")&"1",5,1),3,4),"零","O")&"年"&
MFCNUM(TEXT($MF(日期)$,"MM"),0,1)&"月"&
MFCNUM(TEXT($MF(日期)$,"DD"),0,1)&"日"

谢谢分享，好好学习。。。。。。。。。

SUBSTITUTE(MID(MFCNUM(TEXT($MF(日期2)$,".Y")&1,5,1),3,4)&"年"&TEXT($MF(日期2)$,"MMM")&MFCNUM(TEXT($MF(日期2)$,"D"),0,1)&"日","零","〇")

如何把日期变成中文,666