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

[µo°Ý] ¿é¥X¤é´Á

[µo°Ý] ¿é¥X¤é´Á

¦U¦ì¥ý¶i¡I
°ÝÃD½Ð±Ð¡G
¤wª¾¶g¦¸¤Î¬P´Á¡A¿é¥X¤é´Á¡H

B1.rar (2.05 KB)


«D±`·PÁ«ü¾É:)
100 ¦r¸`¥H¤º
¤£¤ä«ù¦Û©w¸q Discuz! ¥N½X

¥»©«³Ì«á¥Ñ hugh0620 ©ó 2011-1-27 10:53 ½s¿è

¦^´_ 1# b9208


    ¼Ó¥D~ §Aªº·N«ä¬O~
    1.±ø¥ó:¶g¦¸~ ´N¨q¥X¸Ó¶gªº¤é´Á»P¨C­Ó¤é´Á¬O¬P´Á´X¹À???
    2. ±ø¥ó:¶g¦¸»P¬P´Á  ±a¥X¤é´Á¥X¨Ó??

   ¥i¥H½Ð§A§â°ÝÃD¸Ô²Ó»¡©ú~ ¨º¼Ëª©¥D¯Å¤j¤j~ ¤~·|²M·¡¤F¸Ñ~
¾Ç²ß¤~¯à´£¤É¦Û¤v

TOP

Dear hugh

¶g¦¸ (1103) ¤Î¬P´Á (Mon, Tue, .....) ¬O­ì¦³¸ê®Æ¡A§Æ±æ¯à±a¥X¤é´Á¡C

Ths
100 ¦r¸`¥H¤º
¤£¤ä«ù¦Û©w¸q Discuz! ¥N½X

TOP

Dear hugh

¶g¦¸ (1103) ¤Î¬P´Á (Mon, Tue, .....) ¬O­ì¦³¸ê®Æ¡A§Æ±æ¯à±a¥X¤é´Á¡C

Thanks
100 ¦r¸`¥H¤º
¤£¤ä«ù¦Û©w¸q Discuz! ¥N½X

TOP

©êºp¤W¦¸¦^´_«ö¤F¤G¦¸

­è¤~·Q¨ì¨Ï¥ÎIF¨ç¼Æ¤]¥i¥H§¹¦¨»Ý¨D
A2Àx¦s®æ¿é¤J·í¶g(1103)¶g¤@¤é´Á 2011/1/10
A4Àx¦s®æ¿é¤J "=IF(B4="Mon",$A$2,IF(B4="Tue",$A$2+1,IF(B4="Wed",$A$2+2,IF( .................."
100 ¦r¸`¥H¤º
¤£¤ä«ù¦Û©w¸q Discuz! ¥N½X

TOP

¼Ó¥D
¤£ª¾¹D¶Ã¼gªº¬O¤£¬O²Å¦X§Aªº»Ý¨D
B1.rar (5.81 KB)

TOP

¦^´_ 5# b9208

1103
­n§PŪ¬°2011¦~²Ä¤T¶g
½Ð°Ý1911¦~²Ä¤T¶g«ç¼Ëªí¥Ü?
EXCEL³Ì©Èªº´N¬O¤£¿í¦u¸ê®Æ³W®æ
¾Ç®üµL²P_¤£®¢¤U°Ý

TOP

Hsieh ¤j¤j~ »¡ªº¬O¯u²z~

¦]¬°¤@¦~52.142.....¶g~
¨C­Ó¤H¨Ï¥Î­pºâªº²Ä¤@¶gªº¤è¦¡·|¤£¤@¼Ë~   (¨C­Ó¤H§PŪ²Ä¤@¶gªº¤è¦¡¤£¤@¼Ë)
¦p 1/1¬O¦b¬P´Á¤@ ´N²³æ¦h¤F~ ´N¬O·í¦~ªº²Ä¤@¶g
   ­Y 1/1¬O¦b¬P´Á¤» ,«h¦³¨Ç·|±q1/3¬P´Á¤@ ·í¦¨·í¦~ªº²Ä¤@¶g~

³oºØ²Ó¸`´N»Ý­n©w¸q²M·¡~  ·|¤ñ¸û¦n·¡²z~

¤§«eÀ°±Ð±Â»²¾É¤½¥q®É~ ¸ò¦P¾Ç¤]¦³¹J¨ì³o­Ó°ÝÃD~
´N½Ð¤½¥q©w¸q²M·¡­pºâ²Ä¤@¶gªº·Ç«h~ ´N·|«Ü¦n³B²z~  (¨º®É¦P¾Ç¥ÎDELPHI¼¶¼g)
¾Ç²ß¤~¯à´£¤É¦Û¤v

TOP

Dear Eddy,
½Ð°Ý¡ª8-WeekToNum¡ª¬O¤°»ò·N¸q¡H¬°¤°»ò¥Î8´î¡H
WeekToNum¬O¤°»ò·N¸q¡H

Dear Hsieh & hugh
«D±`·PÁ«ü¾É¡A½T¹ê¨S¦³©w¸q凖«h¡C
¶g¦¸©w¸q±q¬P´Á¤@¶}©l
2011/1/1 ©w¸q¬°²Ä¤@¶g¡]¤£ºÞ1/1¬O¬P´Á´X¡^
201101¥Nªí2011¦~²Ä¤@¶g
¥H¤W³]©w¬O§_²Å¦X¸ê®Æ³W®æ

ÁÂÁÂ
100 ¦r¸`¥H¤º
¤£¤ä«ù¦Û©w¸q Discuz! ¥N½X

TOP

  1. Sub XX()
  2. Set d = CreateObject("Scripting.Dictionary")
  3. a = [FLOOR(MID($A$2,3,2)*7+DATE(2000+LEFT($A$2,2),1,1),7)-12]
  4. For i = 0 To 6
  5. d(Format(a + i, "ddd")) = Format(a + i, "yyyy/m/d")
  6. Next
  7. For Each c In Range([b4], [b65536].End(3))
  8. c(1, 0) = d(Application.Proper(c.Value))
  9. Next
  10. End Sub
½Æ»s¥N½X
B1.rar (7.6 KB)

TOP

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