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

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

¸ô¹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

¦^´_ 10# onegirl0204


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

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

=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

        ÀR«ä¦Û¦b : ¤Hªº²´·úªø¦b«e­±¡A¥u¬Ý¨ì§O¤Hªº¯ÊÂI¡Aµ·²@¬Ý¤£¨ì¦Û¤vªº¯ÊÂI¡C
ªð¦^¦Cªí ¤W¤@¥DÃD