我要个EXCEL做一个函数,要求我输入一个固定年月日,系统自动返回一个其...答:假如日期在A2,一个月的日期在B2单元格内输入 =DATE(YEAR(A2),MONTH(A2)+1,DAY(A2))周末顺延 =IF(WEEKDAY(DATE(YEAR(A2),MONTH(A2)+1,DAY(A2)),2)=6,DATE(YEAR(A2),MONTH(A2)+1,DAY(A2)+2),IF(WEEKDAY(DATE(YEAR(A2),MONTH(A2)+1,DAY(A2)),2)=7,DATE(YEAR(A2),MONTH(A2...
想在EXCEL中实现周2周4周日的自动填充该用哪个函数答:比如A列为日期,在B列显示周2周4周日B1输入=IF(WEEKDAY(A1,2)=2,"周二",IF(WEEKDAY(A1,2)=4,"周四",IF(WEEKDAY(A1,2)=7,"周日","")))并向下填充.