八位数日期转换成季度 (9881)

C2="第"&MID("一二三四",(MID(B2,5,2)+2)/3,1)&"季度"

另解=TEXT(LEN(2^MID(B2,5,2)),"[dbnum1]第0季度")

另解=LOOKUP(--MID(B2,5,2),{1,4,7,10},{"第一","第二","第三","第四"})&"季度"