第1个回答 2007-08-31
假定C1单元格用数据有效性设置一个选择(1-12)月份的下拉菜单,A1单元格输入公式:
=IF(C$1="","",IF(C$1<>MONTH(DATE(YEAR(TODAY()),C$1,ROW())),"",DATE(YEAR(TODAY()),C$1,ROW())))
B1单元格输入公式:
=IF(A1="","",CHOOSE(WEEKDAY(A1),"星期天","星期一","星期二","星期三","星期四","星期五","星期六"))
将两个公式向下复制到第31行。本回答被提问者采纳