想问下:在excel中,怎样输入一个日期然后自动显现星期?答:A1)=3,"星期二",IF(WEEKDAY(A1)=4,"星期三",IF(WEEKDAY(A1)=5,"星期四",IF(WEEKDAY(A1)=6,"星期五",IF(WEEKDAY(A1)=7,"星期六")))如果你用的是2007版本,则比较简单 单击数据所在单元格,鼠标右键-设置单元格格式-日期-然后选择右边的“星期三”格式即可 以下是照片截图:...
EXCLE问题:如何提取日期格式中的日数据?并将对应的星期几转换成文本格...答:假设A1为2010/09/01,提取日公式为:=DAY(A1),显示星期公式为:=IF(A1="","","星期"&CHOOSE(WEEKDAY(A1,2),"一","二","三","四","五","六","日")),希望能帮到你!