½Ð°Ý excel ¦p¦ó¦Û°Ê²£¥Í¤ë¥÷¤é¾ä¡H

awen8250

½Ð°Ý excel ¦p¦ó¦Û°Ê²£¥Í¤ë¥÷¤é¾ä¡H

·Q¦Û¤v³]­p¦æ¨Æ¾ä¡A¦ýÁ`¬O¤@­Ó¤@­Ókey

¦³¨S¦³§óÁo©úªº¤è¦¡¡H

hcm19522

http://blog.xuite.net/hcm19522/twblog/354413025

hcm19522

http://blog.xuite.net/hcm19522/twblog/352566544
¸U¦~¾ä °Ñ¦Ò

awen8250

¦^´_ 2# hcm19522


    ¤Ó·PÁ±z¤F¡A§Ú´N¤£¥Î¤@®æ¤@®æ key ¤F¡C

awen8250

½Ð°Ý§Ú¬ã¨s¤F¦n¤[¡A«ç»ò±N¶g¤é²¾¨ì²Ä¤@®æ¡A

¥t¤@­Ó°ÝÃD¬O,§Ú·Q¤¤¶¡´¡¤JªÅ¥Õ¦C¡A«á­±°ÝÃD´N¤£¨£¤F¡A

¨ä¹ê¥i¥H½Æ»s¡u­È¡v¦A°µ­×§ï¡A¦ýÁÙ¬O·Q¦A¦Û°Ê¤@ÂI

·Q½Ð°Ý¤j¤j~ÁÂÁ¡C

mark761222

¦^´_ 1# awen8250


   

¤U¸ü (35.52 KB)

2015-11-8 20:38

=DAY(DATE($G$1,$A$1,1)-(WEEKDAY(DATE($G$1,$A$1,1),1)-1)+COLUMN(A:A)-1+(ROW(1:1)-1)*7)

¬õ¦â³¡¤À¥i¥H¨Ó³]©w¦~ ¤ë

ÄÉ¡C

¦^´_  awen8250


   

=DAY(DATE($G$1,$A$1,1)-(WEEKDAY(DATE($G$1,$A$1,1),1)-1)+COLUMN(A:A)-1+( ...
mark761222 µoªí©ó 2015-11-8 20:39

  ³o­Ó¤½¦¡¤Ó´Î¤F¡A¸Ñ¨M¤F§Úªº°ÝÃD>_<
¦ý³o¤½¦¡¬O±q¨C­Ó¤ëªº¬P´Á¤é¶}©l¡A­Y­n³]©w¨C­Ó¤ë²Ä¤@¤Ñ¬°¬P´Á¤@ªº¸Ü¡AÀ³¸Ó¦pªG³]©w©O?

ML089

¦^´_ 7# ÄÉ¡C


    =DAY(DATE($G$1,$A$1,1)-(WEEKDAY(DATE($G$1,$A$1,1),2)-1)+COLUMN(A:A)-1+(ROW(1:1)-1)*7)

ses26058

1/2/3¥Nªí¤é/¤@/¤G¹ï§a

hcm19522

http://blog.xuite.net/hcm19522/twblog/403105361