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

[µo°Ý] Excel ¦Û°Ê¦~ ¤é´Á©T©w

[µo°Ý] Excel ¦Û°Ê¦~ ¤é´Á©T©w

¦U¦ì¥ý¶i§A¦n:

¤p§Ì·Q­n°µ¤@¤ë¨ì¤Q¤G¤ëÀÉ®×

¤ñ¦p»¡
¤@¤ëÀɮ׶}°_¨Ó¡A¥u·|¶]¤@¤ëªº¤Ñ¼Æ
2014 1/1 1/2 ~ 1/31  
2015 1/1 1/2 ~ 1/31

­ì¥»¬O¦bÀx¦s®æ¸Ì­±ª½±µ¥´ 1/1 ¡A µM«á¦A¥ÎWEEKDAY¥h§PÂ_§«ô´X
¦ý¬O§Ú§ï¦¨2015¦~ ¡AExcel ¦A¶}°_¨Ó
¸Ì­±ÁÙ¬O¤@¼Ë¬O2014

½Ð°Ý³o¼Ë§Ú­n«ç»ò¼g¨ç¼Æ¦bÀx¦s®æ¸Ì­±

Àx¦s®æ¤W¼g ¦~¬O¦Û°Ê§ì¨ú ¤é´Á¬O¼g¦º
§Úª½±µ¦bÀx¦s®æ¤W­±¥´ 1/1 ¡A ¹ê»Ú¬Ý¨ì¸Ì­±¬O¼g 2014/1/1
¨º¦pªG©ú¦~2015 ¶}°_¨Ó¡A ³o¼Ë§ÚªºÀx¦s®æÁÙ¬O¤@¼Ë¬O2014
½Ð°Ý³o¨ç¼Æ­n«ç»ò¼¶¼g?
§A¦n

¦^´_ 1# macacajau
¤u§@ªí©R¦W¥H1~12¬°¦W
©w¸q¦WºÙ
y=YEAR(TODAY())
m=--MID(CELL("filename",!$A$1),FIND("]",CELL("filename",!$A$1))+1,2)
A2¥H¤U¦C¥X¤é´ÁA2¤½¦¡
=IF(MONTH(DATE(y,m,ROW(A1)))<>m,"",DATE(y,m,ROW(A1)))
¦V¤U½Æ»s

¬¡­¶Ã¯1.zip (26.02 KB)
¾Ç®üµL²P_¤£®¢¤U°Ý

TOP

[ª©¥DºÞ²z¯d¨¥]
  • Hsieh(2014-2-27 09:56): ¤w¸g¦³¤W¶Ç¹Ï¤ù¤Î¤½¦¡³]©w»¡©ú¡A½Ð¦Û¦æ°µ°µ¬Ý¤~¯à´£¤É¤½¦¡¨Ï¥Î

¦^´_ 2# Hsieh

ª©¥D§A¦n

¤p§ÌÅv­­¤£°÷¡A©Ò¥H¤£¯à¤U¸üÀÉ®×

¥i§_Mail µ¹§Ú©O?

[email protected]

·PÁÂ
§A¦n

TOP

§A¦n
ÁÙ¬O¬Ý¤£À´
©w¸q¦WºÙ¡A³o¸Ì­Ó¬O¼g¦b­þÃä?
y=YEAR(TODAY())
m=--MID(CELL("filename",!$A$1),FIND("]",CELL("filename",!$A$1))+1,2)

¬P´Á»P¹ê»Ú¤é´Á¡A¬O¦p¦ó¥Í¦¨ªº?

ÁÂÁÂ
§A¦n

TOP

        ÀR«ä¦Û¦b : ¤Hªº¤ß¦a¬O¤@²¥¥Ð¡A¤g¦a¨S¦³¼½¤U¦nºØ¤l¡A¤]ªø¤£¥X¦nªºªG¹ê¡C -
ªð¦^¦Cªí ¤W¤@¥DÃD