zhanghongbing 2007-12-30 22:48
求助
请教老师:
某月的最后一天,用公式怎么表示?
谢谢!!!
hylhjz 2007-12-30 23:05
AA:=MONTH<>REF(MONTH,1);
AB:=REFX(AA,1);
IF(MONTH=9,AB,0);
IF(MONTH=9 AND YEAR=2003,AB,0);
shangjing558 2007-12-31 07:38
[quote]原帖由 [i]hylhjz[/i] 于 2007-12-30 23:05 发表 [url=http://bbs.fjfox.com/redirect.php?goto=findpost&pid=375771&ptid=42741][img]http://bbs.fjfox.com/images/common/back.gif[/img][/url]
AA:=MONTHREF(MONTH,1);
AB:=REFX(AA,1);
IF(MONTH=9,AB,0);
IF(MONTH=9 AND YEAR=2003,AB,0); [/quote]
高人！佩服！学习了，新年愉快！
zhanghongbing 2007-12-31 18:34
谢谢老师！！！