魔方网表中数字日期转换为中文日期的做法.

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,"十六","十七","十八","十九","二十","二十一","二十二","二十三","二十四","二十五","二十六","二十七","二十八","二十九","三十","三十一"))&"日"

晕头，让人家看数字不是更好吗？

不错已经实际应用,感谢!!!!