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

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

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

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

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

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

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

TOP

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

TOP

¦^´_ 2# hcm19522


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

TOP

½Ð°Ý§Ú¬ã¨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

TOP

¦^´_ 1# awen8250


   

=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¦~ ¤ë

TOP

¦^´_  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?

TOP

¦^´_ 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)
{...} ªí¥Ü»Ý­n¥Î CTRL+SHIFT+ENTER ¤TÁä¿é¤J¤½¦¡

TOP

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

TOP

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

TOP

        ÀR«ä¦Û¦b : ­n§åµû§O¤H®É¡A¥ý·Q·Q¦Û¤v¬O§_§¹¬üµL¯Ê¡C
ªð¦^¦Cªí ¤W¤@¥DÃD