Q2：Excel如何将日期转为英文星期?
WEEKDAY(日期)if(WEEKDAY(日期)=7,"SUN",if(WEEKDAY(日期)=1,"MON",...))
Q3：在Excel中如何将日期转为中文的星期几呢？
=IF(WEEKDAY(A1,2)=7,"星期天","星期"&TEXT(WEEKDAY(A1,2),"[dbnum1]"))
Q4：EXCEL如何将日期转换为星期几
你这个不是正经的日期格式，先用数据－分列，选择列数据格式为日期，将格式转化为正确的日期格式，然后在旁边的辅助列D2输入公式＝TEXT(C2，"aaaa"),向下填充公式
