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

[µo°Ý] ¤w¸Ñ¨M/³Â·Ð¤j®aÀ°¦£¤F¡A§Ú»Ý­n°µ¨ì´Á¤é¬ÛÃöªº¨ç¼Æ

[µo°Ý] ¤w¸Ñ¨M/³Â·Ð¤j®aÀ°¦£¤F¡A§Ú»Ý­n°µ¨ì´Á¤é¬ÛÃöªº¨ç¼Æ

¥»©«³Ì«á¥Ñ s10002096 ©ó 2011-12-6 19:00 ½s¿è


³Â·Ð¤j®aÀ°¦£¤F¡A§Ú»Ý­n¤@´Á¬°¥|­Ó¤ëªº¨ì´Á¤é¡A¦ý¤S­n¦Ò¼{¨ì¶|¤ëªº³øªí¡A¦pªþ¹Ï¨º¼Ë¡A¥i¥HÀ°§Ú¼g¦n¨ç¼Æ¶Ü¡H§Ú·|¨Ì·Ó¼g¦nªº¨ç¼Æ°µ­Ó¾Ç²ß¡A¬d¤F«Ü¦h¸ê®Æ¡A¦ý¯u±o¤£ª¾¹D¸Ó¦p¦ó¼g¥X¦Ò¼{¶|¤ëªº¨ç¼Æ¡C
¥t¥~½ÐÀ°§Ú°µ¥X´£¿ô¨ºÄæ¡A»Ý­n¤T­Ó¤ë¨ì´N¥HÃC¦â¼Ð¥Ü±N¨ì´Áªº¨ç¼Æ¦n¶Ü¡H
ÁÂÁ¤j®a¡A³Â·Ð¤F¡C

¥¼©R¦W.jpg (12.83 KB)

¨ì´Á¤é

¥¼©R¦W.jpg

H2=DATE(YEAR(G2),MONTH(G2)+4,DAY(G2))
i2=IF(TODAY()>=DATE(YEAR(G2),MONTH(G2)+3,DAY(G2))," ±N¨ì´Á","")

TOP

¦^´_ 2# oobird


­è­è´ú¸Õ¤F¤@¤U«e½úªº¤½¦¡¡Aµo²{¦³­Ó¤p·å²«¡ã­Y²Ä¤@Ä檺ñ¬ù¤é¬OªÅ¥Õ®É¡A«á­±ªºÄæ¦ì¸ê®Æ·|¥X²{¿ù»~°T®§¡A½Ð°Ñ¦Òªþ¥ó²Ä¤»¤Î²Ä¤C¦C¸ê®Æ¡C

TOP

¥»©«³Ì«á¥Ñ s10002096 ©ó 2011-12-3 15:42 ½s¿è

ÁÂÁ¼ӤWª©¤jªºÀ°¦£¡A¥Ø«eªí®æ¥i¥H¹Bºâ¤F¡C
¥t¥~°Ñ¦Ò¤F¤j¨ç¼Æ¡A·Q¦h³]©w±ø¥ó¡G¶W¹L¢³­Ó¤ëªº®É­Ô·|Åã¥Ü¤w¨ì´Á¡A¦ý«ç»ò³]©w³£¿ù¡@orz¡C
½Ð°Ý¥i¥H¦A³Â·Ðª©¤j­Ì¤@¦¸¶Ü?

¦ÓÃC¦âªº³¡¤À¦b³]©w®æ¦¡¤Æ±ø¥ó¨º¡A­n¥´¤W¤°»ò¤½¦¡©O¡HÈбN¨ì´ÁÈÐÅã¥Üºñ¦â¡CÈФw¨ì´ÁÈÐÅã¥Ü¬õ¦â¡C


---------------------------------------------------------------

TOP

¦^´_ 4# s10002096

I2=IF(TODAY()>=DATE(YEAR(G2),MONTH(G2)+4,DAY(G2))," ¤w¨ì´Á",IF(TODAY()>=DATE(YEAR(G2),MONTH(G2)+3,DAY(G2))," ±N¨ì´Á",""))

³]©w®æ¦¡¤Æ±ø¥ó
¥ý¿ïIÄæ
±ø¥ó1: Àx¦s®æ ­È µ¥©ó ¤w¨ì´Á
                 ®æ¦¡ ¿ï¬õ¦â
±ø¥ó2: Àx¦s®æ ­È µ¥©ó ±N¨ì´Á
                 ®æ¦¡ ¿ïºñ¦â

TOP

ÁÂÁ¼ӤWªºª©¤j¡A¨ì´Á¤éªº°ÝÃD¤w¸Ñ¨M¢X
¦ýÃC¦â³]©wÁÙ¬O¤£¦æ¡A³]©w¤§«áÃC¦â³£¤£·|ÅÜ¡C
¸Õ¤F«Ü¦h¦¸¡C orz

TOP

¦^´_ 6# s10002096


    ¤½¦¡¸Ì " ¤w¨ì´Á"   " ±N¨ì´Á"  ¸Ì­±¦n¹³¦h«ö¤F­ÓªÅ¥ÕÁä

TOP

¼P«¢¡AÃø©Ç§Ú«ç»ò³]©w³£¤£¦æ orz
²{¦b¤w¸g§¹¦¨³øªí¤F¡AÁÂÁ¼ӤWª©¤j­ÌªºÀ°¦£¡AÁÂÁ§A­Ì¢X

TOP

        ÀR«ä¦Û¦b : ¡i¥Í©R¦b©I§l¶¡¡j¦òªû»¡¡G¡u¥Í©R¦b©I§l¶¡¡C¡v¤HµLªkºÞ¦í¦Û¤vªº¥Í©R¡A§óµLªk¾×¦í¦º´Á¡AÅý¦Û¤v¥Ã¦í¤H¶¡¡C¬JµM¥Í©R¥h¨Ó³o»òµL±`¡A§Ú­Ì§óÀ³¸Ó¦n¦n¦a·R±¤¥¦¡B§Q¥Î¥¦¡B¥R¹ê¥¦¡AÅý³oµL±`¡BÄ_¶Qªº¥Í©R¡A´²µo¥¦¯uµ½¬üªº¥ú½÷¡A¬M·Ó¥X¥Í©R¯u¥¿ªº»ù­È¡C
ªð¦^¦Cªí ¤W¤@¥DÃD