...一个周日是哪天啊,例如2013年1月份怎么知道是一月6号呢答:函数weekday()可以获取一周的日子,默认周日是1 示例:A1:2013-1-1 B1:=IF(WEEKDAY(H1)=1,H1,IF(WEEKDAY(H1+1)=1,H1+1,IF(WEEKDAY(H1+2)=1,H1+2,IF(WEEKDAY(H1+3)=1,H1+3,IF(WEEKDAY(H1+4)=1,H1+4,IF(WEEKDAY(H1+5)=1,H1+5,IF(WEEKDAY(H1+6)=1,H1+6,IF(...