<p>公式:</p><p>=IF(MONTH(B5)=MONTH(DATE(YEAR(B5),MONTH(B5),1)-WEEKDAY(DATE(YEAR(B5),MONTH(B5),1))+1+{0;1;2;3;4;5}*7+{0,1,2,3,4,5,6}),DATE(YEAR(B5),MONTH(B5),1)-WEEKDAY(DATE(YEAR(B5),MONTH(B5),1))+1+{0;1;2;3;4;5}*7+{0,1,2,3,4,5,6},"")</p><p>太烦琐,还是数组.</p><p>建议参考:</p><p><a href="http://www.officefans.net/cdb/viewthread.php?tid=86134&highlight=%C8%D5%C0%FA%2Bwshcw" target="_blank">简易日历工作表中的公历部分公式如何写才能统一?(2007-12-27答案更新)</a> </p>
[此贴子已经被作者于2008-12-5 10:36:32编辑过] |