- ©«¤l
- 233
- ¥DÃD
- 53
- ºëµØ
- 0
- ¿n¤À
- 292
- ÂI¦W
- 0
- §@·~¨t²Î
- WinXp
- ³nÅ骩¥»
- 2010
- ¾\ŪÅv
- 20
- ©Ê§O
- ¨k
- µù¥U®É¶¡
- 2012-1-6
- ³Ì«áµn¿ý
- 2024-3-8
|
¦^´_ 7# eghost
³o¼Ë²Ä¥|ÂI±ø¥ó´NnÀu¥ý²Ä2©Î3¶µ±Æ§Ç
§Ú§â¤½¦¡±ø¥ó©ñ¦b²Ä1§PÂ_
=IF(AND(TODAY()>A2,LEN(A3)>0),A3-TODAY(),IF(AND(LEN(A2)<1,LEN(A3)<1),A1-TODAY(),IF(LEN(A2)>0,A2-TODAY(),IF(LEN(A3)>0,A3-TODAY(),IF(AND(LEN(A2)>0,LEN(A3)>0),A2-TODAY(),"")))))
¦b´ú¸Õ¬Ý¬Ý¦³¨S¦³²Å¦X§a |
|