[µo°Ý] ½Ð±Ð¡G¤Ñ¼Æªº§PÂ_°ÝÃD

onegirl0204

½Ð±Ð¦U¦ì«e½ú¡ã

¢ÑÄ欰¥d¤ù¦³®Ä¤é´Á¡A§Ú·Q¦b¢ÒÄ楴¤J¨ç¼Æ¥H«K§PÂ_¬°¡©¥¼¨ì´Á¡ª¡B¡©±N¨ì´Á¡ª©Î¡©¤w¹L´Á¡ª
§PÂ_±ø¥ó¬°¡ã¡©¥¼¨ì´Á¡ª¡G¥d¤ù¦³®Ä¤é´Á¡@´î¡@¤µ¤Ñªº¤é´Á¡@¤j©ó¡@¢²¢°¤Ñ
¡@¡@¡@¡@¡@¡@¡©±N¨ì´Á¡ª¡G¥d¤ù¦³®Ä¤é´Á¡@´î¡@¤µ¤Ñªº¤é´Á¡@¤p©ó©Îµ¥©ó¡@¢²¢°¤Ñ
¡@¡@¡@¡@¡@¡@¡©¤w¹L´Á¡ª¡G¥d¤ù¦³®Ä¤é´Á¡@´î¡@¤µ¤Ñªº¤é´Á¡@¤p©ó©Îµ¥©ó¡@¢¯¤Ñ
¥t¥~¡A·í¢ÑÄ欰ªÅ¥Õ®É¡A¢ÒÄæ¥ç¦P®É¦Û°ÊÅã¥ÜªÅ¥Õ

¤£ª¾¨ç¼Æ¸Ó¦p¦ó³]©w¡H·Ð½Ð¦U¦ì«e½ú½ç±Ð¡A·P®¦¡I

kkooo15

=IF(C10="","",LOOKUP(C10-TODAY(),{-99999,1,31},{"¤w¹L´Á","±N¨ì´Á","¥¼¨ì´Á"}))

¤U¸ü (25.63 KB)

2013-1-16 11:07

=IF(E10="","",TEXT(E10-TODAY()-1,"[>30]¥¼¨ì´Á;¤w¹L´Á;±N¹L´Á;"))

¤U¸ü (26.15 KB)

2013-1-16 11:07

=IF(G10="","",TEXT(G10-TODAY(),"[>31]¥¼¨ì´Á;[<=0]¤w¹L´Á;±N¨ì´Á;"))

¤U¸ü (25.9 KB)

2013-1-16 11:08

§Ú¤]«Ü¦n©_¬°¤°»ò²Ä¤T­Ó¤è¦¡·|¦³­t¸¹¥X²{

onegirl0204

¦^´_ 12# Hsieh


«D±`·PÁ±zªº½ç±Ð¡I§Ú¤@ª½°g¥¢¦b¡©¤w¹L´Á¡ª¤Î¡©±N¨ì´Á¡ª¦r²´¤W¦p¦ó¥HÃC¦â°Ï¤À¡H¥H­P©ó«ä¦Ò¤è¦V°¾©ó¥H¤å¦r§@¬°±ø¥ó®æ¦¡¤Æ¤§§PÂ_±ø¥ó¡A«o©¿²¤¤F³Ì²³æªº¤é´Á¬Û´î²£¥Íªº¼Æ¦r§@¬°§PÂ_¤½¦¡¨Ì¾Ú¡A¦A¦¸·PÁ±zªº´£ÂI¡I

Hsieh

¦^´_ 10# onegirl0204


   

¤U¸ü (42.42 KB)

2013-1-13 17:18

adam2010

¸ô¹L°½¾Ç¡A­ì¨Ó¥i¥H¥Î°}¦Cªº¤è¦¡¡A¤£µM¥H«e¨C¦h¤@­Ó§P©w§Ú´N¦h¤@¼hIF°j°é¡A·d±o¤½¦¡"°Ç°Çªø"¡A³o¤U¤l¨ü±Ð¤F¡A³o¸Ì¯u¬O¤@­Ó¦n©Ò¦b¡AÁÂÁÂÅo~
=IF(C2="","",LOOKUP(C2-TODAY(),{-99999,1,7,14,31},{"¤w¹L´Á","±N¨ì´Á","¤@¶g¤º","2¶g¤º","¥¼¨ì´Á"}))

onegirl0204

¦^´_ 6# JBY


«D±`·PÁ±zªº«ü±Ð¡I

½Ð§_¦A¦¸½Ð±Ð¡G¦p¦ó³]©w¤w¹L´ÁÃC¦â¬°¬õ¦â¦rÅé¡A¦Ó±N¹L´Á«h¬OÂŦâ¦rÅé¡H¦]¬°§Ú¤£ª¾¦p¦ó¦b±ø¥ó®æ¦¡¸Ì³]©w¤½¦¡¡H

·Ð½Ð½ç±Ð¡A·P®¦¡I

onegirl0204

¦^´_ 8# zz5151353


±z¦n¡ã

­º¥ý·PÁ±zªº«ü±Ð¡I­ì«h¤W¬O¥X²{§Ú­nªºµ²ªG¡A¥i¬O¦³¤@ÂI¤£©ú¥Õ¦â¬°¦ó¤w¹L´Áªº¥ª°¼·|¦h¥X­t¸¹©O¡H

¥t¥~¡A¦p¦ó³]©w¤w¹L´ÁÃC¦â¬°¬õ¦â¦rÅé¡A¦Ó±N¹L´Á«h¬OÂŦâ¦rÅé¡H¦]¬°§Ú¤£ª¾¦p¦ó¦b±ø¥ó®æ¦¡¸Ì³]©w¤½¦¡¡H·Ð½Ð½ç±Ð¡A·P®¦¡I

zz5151353

=IF(C1="","",TEXT(C1-TODAY(),"[>31]¥¼¨ì´Á;[<=0]¤w¹L´Á;±N¨ì´Á;"))

freeffly

¦^´_ 6# JBY


    ­ì¨Ó®æ¦¡¤]¥i¥H³o¼Ë³B²z
   ¾Ç²ß¤F

JBY

=IF(C2="","",TEXT(C2-TODAY()-1,"[>30]¥¼¨ì´Á;¤w¹L´Á;±N¹L´Á;"))