excel日期与周转换问题答:在B5单元格输入 =(DATEDIF(A1,A2,"D")-(7-WEEKDAY(A1,2))+(7-WEEKDAY(A2,2)))/7 那么周一的统计是 =IF(1>=WEEKDAY(A1,2),(IF(1>WEEKDAY(A2,2),B5,B5+1)),(IF(1>WEEKDAY(A2,2),B5-1,B5)))周二 =IF(2>=WEEKDAY(A1,2),(IF(2>WEEKDAY(A2,2),B5,B5+1)),(IF(...
...提取日期格式中的日数据?并将对应的星期几转换成文本格式?答:假设A1为2010/09/01,提取日公式为:=DAY(A1),显示星期公式为:=IF(A1="","","星期"&CHOOSE(WEEKDAY(A1,2),"一","二","三","四","五","六","日")),希望能帮到你!
请问EXCEL如何用函数将1,2,3...7转换成星期一,二,三...日答:=CHOOSE(WEEKDAY(TODAY(),2),"星期一","星期二","星期三","星期四","星期五","星期六","星期日")