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

[µo°Ý] ¨D¸Ñ¦h±ø¥ó²[¼Æ

[µo°Ý] ¨D¸Ñ¦h±ø¥ó²[¼Æ

¨D¸Ñ¦h±ø¥ó²[¼Æ

      A          B            C     
1  ¤é¼Æ   §¹¤u¤é    ¶}¤u¤é
2   ¡H         2/6        1/15
3

¨DAÄæ¦ìÅã¥Ü
1.µL¶}¤u¤é®É¡GªÅ¥Õ
2.µL¶}¤u¤é¡A¦³§¹¤u¤é¡G¿ù»~
3.¦³¶}¤u¤é¡AµL§¹¤u¤é¡A¦ýtoday-¶}¤u¤é>7®É¡G¶W®É
4.¦³¶}¤u¤é¡A¦³§¹¤u¤é¡GÅã¥Ü"¡H"¤Ñ
robin

¨S¤H¦^µª§Ú¡A¥u¦n¦Û¤v¨ì³B§äµª®×¡A¦³µ²ªG¤F¡AªGµMµý©ú§Ú«Üµæ¡A¦]¬°ª¾¨äµM¡A¤£ª¾©Ò¥HµM¡C
¤£¹L¡AÁÙ¬O¼Ö·N»P¤j®a¤À¨É
=CHOOSE((B2="")+(C2="")*2+1,B2-C2&"¤Ñ",IF(TODAY()-C2>7,"¶W®É",""),"¿ù»~","")
robin

TOP

        ÀR«ä¦Û¦b : ¤@­Ó¤Hªº§Ö¼Ö¡D¤£¬O¦]¬°¥L¾Ö¦³±o¦h¡A¦Ó¬O¦]¬°¥L­p¸û±o¤Ö¡C
ªð¦^¦Cªí ¤W¤@¥DÃD