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

[µo°Ý] ¦p¦ó­pºâ¥X¦Ü¤µ¦~¢µ¤ë©³¬°¤î¡A­Ó¤Hªº¦~Ä֤βέp¦U¦~ÄÖ¼hªº¤H¼Æ

[µo°Ý] ¦p¦ó­pºâ¥X¦Ü¤µ¦~¢µ¤ë©³¬°¤î¡A­Ó¤Hªº¦~Ä֤βέp¦U¦~ÄÖ¼hªº¤H¼Æ

¢Ï¢°¥H¤UÀx¦s®æ¬°¤H¦W
¢Ð¢°¥H¤UÀx¦s®æ¬°¥X¥Í¦~¤ë¤é
¢Ñ¢°¥H¤UÀx¦s®æ¬O¨ì¤µ¦~¢µ¤ë©³¬°¤î¡A»P¢Ð¢°¹ïÀ³¤§¦~Ä֡㦹Äæ¦ìªº¸ê®Æ¸Ó¦p¦ó³]©w¤½¦¡¡H
¢Ô¢°¡G¡@¥¼º¡¢°¢±·³ªº¤H¼Æ
¢Ô¢±¡G¢°¢±¡ã¢°¢¶·³ªº¤H¼Æ
¢Ô¢²¡G¢°¢·¡ã¢±¢¸·³ªº¤H¼Æ
¢Ô¢³¡G¢²¢¯¡ã¢³¢¸·³ªº¤H¼Æ
¢Ô¢´¡G¢´¢¯¡ã¢´¢³·³ªº¤H¼Æ
¢Ô¢µ¡G¢´¢´¡ã¢µ¢³·³ªº¤H¼Æ
¢Ô¢¶¡G¡@¢µ¢´·³¥H¤Wªº¤H¼Æ

«ô°U¦U¦ì«e½ú­Ì½ç±Ð¡A·P®¦¡I

c1=DATEDIF(B1,"2012/6/30","y")
f1=COUNTIF(C1:C6,"<12")
f2=COUNTIF(C1:C12,">12")-COUNTIF(C1:C12,">=17")

TOP

¦^´_ 2# ANGELA


·PÁ«e½ú½ç±Ð¡I

¦A½Ð±Ð¤@¤U¡ã¦]¬°¦~»P¤ëªº¤½¦¡¬O¤À¶}­pºâªº¼Æ¦r¡A­Y·Qºâ¥Xµê·³¦~ÄÖ¡A¤½¦¡¸Ó¦p¦ó­×¥¿¡H·Ð½Ð¦A¦¸½ç±Ð¡A·P®¦±z¡I

TOP

¦^´_ 3# onegirl0204

µê·³¤£´N¬O¦~¥÷¬Û´î¦Ó¤w¶Ü?
=YEAR(TODAY())-YEAR(¥Í¤é)
¾Ç®üµL²P_¤£®¢¤U°Ý

TOP

        ÀR«ä¦Û¦b : ¡i®É¤é²öªÅ¹L¡j¤@­Ó¤H¦b¥@¶¡°µ¤F¦h¤Ö¨Æ¡A´Nµ¥©ó¹Ø©R¦³¦hªø¡C¦]¦¹¥²¶·»P®É¶¡Ävª§¡A¤Á²ö¨Ï®É¤éªÅ¹L¡C
ªð¦^¦Cªí ¤W¤@¥DÃD