是纯文本的8位数字,20150101最终目的是转化成星期几,求帮忙
假设数字在A1单元格,B1输入公式=WEEKDAY(TEXT(A1,"0000-00-00"),2)
可以得到对应的星期数。
=CHOOSE(WEEKDAY(TEXT(A2,"0000-00-00"),2),"星期一","星期二","星期三","星期四","星期五","星期六","星期日")