ªð¦^¦Cªí ¤W¤@¥DÃD µo©«

[µo°Ý] ®æ¦¡¤Æ±ø¥ó³]©w°ÝÃD¡]¤w¸Ñ¨M¡^

[µo°Ý] ®æ¦¡¤Æ±ø¥ó³]©w°ÝÃD¡]¤w¸Ñ¨M¡^

¥»©«³Ì«á¥Ñ onegirl0204 ©ó 2010-11-13 22:30 ½s¿è

LÄ槡¬°¥X¥Í¦~¤ë¤é¸ê®Æ¡A°²³]L3ªº¸ê®Æ¬°85/11/15¡A§Ú¦bM¢²³]=TEXT(L3,"MMDD")µ²ªG·|¥X²{1115¡ATEXT(TODAY(),"mmdd")«h·|¥X²{1113¡A¨º»ò¦b¢Ü¢²³]M3-TEXT(TODAY(),"mmdd")·|±o¨ì¼Æ¦r¢±¡ã²Å¦X§Ú­nªº±ø¥ó¡ã¥Í¤é¶ZÂ÷¤µ¤Ñ¢¶¤Ñ¤ºªº¤H¨ä¥X¥Í¦~¤ë¤é¨º¤@®æ·|¶ñº¡¬õ¦â¡A¤£ª¾¾ã­Ó¸ê®Æ®wªº®æ¦¡¤Æ±ø¥ó¸Ó¦p¦ó³]©w¡H½Ð¦U¦ì«e½ú«ü±Ð¡AÁÂÁ¡I

¥»©«³Ì«á¥Ñ oobird ©ó 2010-11-13 08:41 ½s¿è

­Y¤é´Á±qL3¶}©l¡A¥þ¿ïL3¥H¤Uªº¤é´Á½d³ò¡A±ø¥ó®æ¦¡¿é¤J=AND(DATEDIF($L3,TODAY(),"YD")<=7,DATEDIF($L3,TODAY(),"YD")>=0)

TOP

=DATEDIF($L3,TODAY(),"YD")<=7
À³¸Ó´N¥i¥H¤F,¤£·|¦³¤p©ó0ªº°ÝÃD
ª¾¤§¬°ª¾¤§¡A¤£ª¾¬°¤£ª¾¡A¸Û¹ê¤]¡I

TOP

©Ó±Ð¤F¡A«Ü¤Ö¥Î³o­Ó¨ç¼Æ¡A¨S·Q¨ì"YD"°Ñ¼Æ·|¦b¤p©ó0®É¥H¥þ¦~¤é¼Æ­pºâ¡I

TOP

¦^´_ 3# gong


·PÁ±z¤Îoobirdªº±Ð¾É¡I¨Ì¾Úoobird«e½ú©Ò¨¥¡A¿ï¨úL¢²¡ãL¢´¢³µM«á¨Ì¾Ú±z«Øijªº³]©w±ø¥ó¤Æ®æ¦¡¡A«ö§¹½T©wÁä«á¥Í¤é¬°¢°¢°¡þ¢°¢·ªº¾Ç¥ÍÀx¦s®æ³ºµM¨S¦³¶ñº¡¬õ¦â¡H¤£ª¾°ÝÃD¥X¦b¦ó³B¡H©|½Ð½ç±Ð¡AÁÂÁ¡I

TOP

¤u¨ã>¼W¯q¶°>¤ÀªR¤u¨ã½c¥´¤Ä
ª¾¤§¬°ª¾¤§¡A¤£ª¾¬°¤£ª¾¡A¸Û¹ê¤]¡I

TOP

¦^´_ 6# gong


¤£¦n·N«ä¡ã¤´µM¦³°ÝÃD­C¡Iªþ¤WÀÉ®×½ÐÀ°¦£¬d¬Ý°ÝÃD©Ò¦b¡HÁÂÁ¡I ¢¶¤Ñ¤º¥Í¤éªº¾Ç¥Í.rar (4.54 KB)

TOP

=DATEDIF($D3+1,TODAY(),"YD")>=358
³o¼Ë¸Õ¸Õ¬Ý
ª¾¤§¬°ª¾¤§¡A¤£ª¾¬°¤£ª¾¡A¸Û¹ê¤]¡I

TOP

¹ï¤£°_¡A¨S¦³¤å¥ó´ú¸Õ¡A·Q±o¤Ó³æ¯Â¤F¡C
¢¶¤Ñ¤º¥Í¤éªº¾Ç¥Í.rar (4.85 KB)

TOP

¦^´_ 8# gong


¯u¬O¤Ó·PÁ±z¡ã¤w¸g¦¨¥\¤F¡I

TOP

        ÀR«ä¦Û¦b : ¯àµ½¥Î®É¶¡ªº¤H¡A¥²¯à´x´¤¦Û¤v§V¤Oªº¤è¦V¡C
ªð¦^¦Cªí ¤W¤@¥DÃD