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

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

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

½Ð±Ð¦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

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


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


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


§Ú¤]«Ü¦n©_¬°¤°»ò²Ä¤T­Ó¤è¦¡·|¦³­t¸¹¥X²{
excel¾Ç²ß¤¤!¿v¥X¹Ú·Q
https://www.youtube.com/channel/UCPAiRNsHX3k_omp0YDgfDiA

TOP

¦^´_ 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

TOP

¦^´_ 10# onegirl0204


   
¾Ç®üµL²P_¤£®¢¤U°Ý

TOP

¸ô¹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¤º","¥¼¨ì´Á"}))
Adam

TOP

¦^´_ 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

TOP

¦^´_ 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

TOP

=IF(C1="","",TEXT(C1-TODAY(),"[>31]¥¼¨ì´Á;[<=0]¤w¹L´Á;±N¨ì´Á;"))
300 ¦r¸`¥H¤º
¤£¤ä«ù¦Û©w¸q Discuz! ¥N½X

TOP

¦^´_ 6# JBY


    ­ì¨Ó®æ¦¡¤]¥i¥H³o¼Ë³B²z
   ¾Ç²ß¤F
¦r¨å¨â¦U¦r ÁÙ¯uÃø²z¸Ñ

TOP

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

µû¤À¤H¼Æ

    • Hsieh: §®©Û!!ª÷¿ú + 2

TOP

        ÀR«ä¦Û¦b : ¯u¥¿ªº·R¤ß¡A¬O·ÓÅU¦n¦Û¤vªº³oÁû¤ß¡C
ªð¦^¦Cªí ¤W¤@¥DÃD