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

[µo°Ý] ¤½¦¡¦Û°Ê®ø¥¢

[µo°Ý] ¤½¦¡¦Û°Ê®ø¥¢

§Ú¦bÀx¦s®æ¤º¿é¤J=TEXT(B6,"MMDD")&" "&LEFT(D6,2)&" Onduty Report by "&vlookup(F6,Z5:AA15,2,FALSE)&" & "&vlookup(F8,Z5:AA15,2,FALSE)
B6=2013/8/10
D6=DA1
«á­±ªº¤½¦¡¥u¬O¹ï·Ó¤¤­^¤å©m¦W

¬°¦ó³o­Ó¤½¦¡
·|«D±`¯«©_ªº
¦Û¤vÅܦ¨"­È"
´N¬OÅܦ¨0810 DA Onduty Report by YF & Bob
µM«á=®ø¥¢¤F¡A¤½¦¡¤º®e®ø¥¢¤F¡A´N³o¼ËÅܦ¨­È¤F...
§Ú©ú©ú¬O¥´µ¥¸¹¡A«ç·|ÅÜ­È¡A¦Ó¥BÅܪº®É¶¡ÂIÁÙ"¤£¤@©w"
§Ú¤]·d¤£À´¬Æ»ò±¡ªp¤U·|Åܦ¨­È¡A¬Æ»ò±¡ªp¤U·|ÁÙ¬O¤½¦¡
¾É­P§ÚªºexcelªíµLªk¨Ï¥Î

§Ú¦P¨Æ¤]µo¥Í¹L³oºØ±¡ªp
½Ð°Ý¦³¤Hª¾¹D­ì¦]&¸Ñ¨M¤èªk¶Ü?
(¨Ï¥Îexcel¤w¸g7¦~¤F¡A²Ä¤@¦¸¹J¨ì)
PKKO

[ª©¥DºÞ²z¯d¨¥]
  • Hsieh(2013-8-12 00:00): À³¸Ó´N¬O³o­Ó­ì¦]¤F

¦^´_ 1# PKKO


    ¦³°ÝÃDªºÀx¦s®æ¡A¬O§Ú¥Î¦Û­qªí³æ¤ºtextboxªºcontrolsourceªºÀx¦s®æ
·|¬O¦]¬°³o­Ó­ì¦]¾É­P¥L¤½¦¡®ø¥¢¡A¦Û°ÊÅܦ¨­È¶Ü?
PKKO

TOP

        ÀR«ä¦Û¦b : ¨C¤ÑµL©Ò¨Æ¨Æ¡A¬O¤H¥Íªº®ø¶OªÌ¡A¿n·¥¡B¦³¥Î¤~¬O¤H¥Íªº³Ð³yªÌ¡C
ªð¦^¦Cªí ¤W¤@¥DÃD