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"),向下填充公式