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

[µo°Ý] ³]©w®æ¦¡¤Æªº±ø¥ó

D3¤¶©ó¤C¤Ñ¤º, D3Àx¦s®æ¶ñº¡¶À¦â
ªº·N«ä¬O>TODAY()-7¥B<TODAY()+7¶Ü?
¾Ç®üµL²P_¤£®¢¤U°Ý

TOP

¦^´_ 3# ClareWu


   
³]©w®æ¦¡¤Æ.rar (146.34 KB)
¾Ç®üµL²P_¤£®¢¤U°Ý

TOP

¦b Excel 2010 ¤¤¡A³]©w®æ¦¡¤Æªº±ø¥ó³Ì¦h¥i¥H¥]§t¤»¤Q¥|­Ó±ø¥ó¡A¦ý¬O¦b Excel 97-2003 ¤¤¡A¥u·|¬Ý¨£«e¤T­Ó±ø¥ó¡C
¾Ç®üµL²P_¤£®¢¤U°Ý

TOP

¦^´_ 10# gn00487767

®æ¦¡³]©w¥u¯à¦r«¬ÃC¦â³]©w
¥Î¤½¦¡­pºâ¥X¦~ÄÖ«á¡A§PÂ_¼Æ­È
    [ºñ¦â][<20]G/³q¥Î®æ¦¡;[¬õ¦â][>80]G/³q¥Î®æ¦¡;G/³q¥Î®æ¦¡

ª½±µ¥Ñ¥X¥Í¤é´Á§PÂ_¦~ÄÖÅܦâ
¨Ï¥Î®æ¦¡¤Æ±ø¥ó

¿ï¨úAÄæ
¬õ¦â
=($A1<>"")*(DATEDIF($A1,TODAY(),"Y")>80)
ºñ¦â
=($A1<>"")*(DATEDIF($A1,TODAY(),"Y")<20)
¾Ç®üµL²P_¤£®¢¤U°Ý

TOP

        ÀR«ä¦Û¦b : ¤p¨Æ¤£°µ¡B¤j¨ÆÃø¦¨¡C
ªð¦^¦Cªí ¤W¤@¥DÃD