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

Ãö©óweeknum¨Ï¥Î­­¨î?

Ãö©óweeknum¨Ï¥Î­­¨î?

¥»©«³Ì«á¥Ñ vvcvc ©ó 2012-2-21 14:46 ½s¿è

§Ú¦b¤pÀ°¤â¨º¸Ì¬d¨ì³o­Ó¨ç¦¡
¥»·Q¨Ï¥Î¥L¨Ó°µ¶g²Î­pªº¤ñ¹ï¥[Á`
¦ý¨S·Q¨ì³s¨Ï¥Î½d¨Ò³£¥u·|¥X²{#NAME?
¤£ª¾¬O¤£¬O¦³¤°»ò¨Ï¥Î­­¨î?
(W01ªº¤½¦¡¥Ø«e¥X²{¿ù»~¡A¬G°£¤Fweeknumªº°ÝÃD¡AÁÙ¤£ª¾¹D¬O¤£¬OÁÙ¦³¨ä¥L°ÝÃD¦s¦b)

ªþ¥ó©|¦³¤@­Ó°ÝÃD¡A§ÚÀx¦s®æ©¹¥k©Ô³Ì¦h¥u¯à©Ô¨ì9/11
°£¤F§ï¦¨ª½¦¡¥H¥~­n«ç¼Ë¤~¯à¦AÂX®i?
«ç¼Ë¤~¯à©Ôº¡¤@¾ã­Ó¦~«×?

¤½¥qªº¹q¸£¥u´£¨Ñoffice 2003ª©¡A©Ò¥H®a¤¤¤]°t¦X¨Ï¥Î2003ª©
¬G§Æ±æ¤j®a´£¨Ñªº¤èªk¬O¥i¥H¦b2003ª©¹ê²{ªº¤è¦¡
Book1.rar (6.37 KB)

¦^´_ 1# vvcvc


    WEEKNUM¬O¤ÀªR¤u¨ã½c¼W¯q¶°¤¤ªº¨ç¼Æ
½Ð¤Ä¿ï
¤u¨ã/¼W¯q¶°/¤ÀªR¤u¨ã½c

2003ª©¬°256Ä檺¤u§@ªí
¦Ó¤@¦~¦Ü¤Ö365¤Ñ¡A¨º°£¤F¤À¦C©ñ¸m¥~À³µLªk®e¯Ç
¾Ç®üµL²P_¤£®¢¤U°Ý

TOP

¥»©«³Ì«á¥Ñ vvcvc ©ó 2012-2-21 15:33 ½s¿è

ÁÂÁª©¥D
¦w¸Ë«áµo²{weeknumµLªk¨Ï¥Î½d³ò¨Ó°µ­pºâ
¦Ó¥B1»P01ªº¤ñ¹ïµ²ªG¤]¬O¿ù»~ªº(¥i¥H¥[¤Jvalue¸Ñ¨M)
¦ýweeknumªº°ÝÃD¡A¤£ª¾¸Ó«ç»ò¸Ñ¨M?

TOP

¹ï¤F¡A¶¶«K°Ý¤@¤U
¤ë¡B©uªº³¡¥÷
§Ú¨Ï¥Î«Ü²Âªº¤èªk¤@®æ¤@®æ©Ô½d³ò
¦³¤°»ò¤èªk¥i¥H¼g¦bB7¡BF7«á¦V¥k¦V¤U©Ô³£¾A¥Î¶Ü?

TOP

¥»©«³Ì«á¥Ñ register313 ©ó 2012-2-21 18:05 ½s¿è

¦^´_ 4# vvcvc

256Äæ®e¯Ç¤£¤U

¬O¤£¬O¥ý½T©w­n¤£­nÂনª½¦V
Âনª½¦V¤]¤ñ¸û¦n¤U¤½¦¡
Q1:  weeknumµLªk¨Ï¥Î½d³ò  ==>  ¥[»²§UÄæ¥ý¨D±o¨C­ÓÀx¦s®æ¤§weeknum
Q2,Q3¤]³£¥i¸Ñ¨M



Book.rar (6.39 KB)

TOP

¦^´_  vvcvc

256Äæ®e¯Ç¤£¤U

¬O¤£¬O¥ý½T©w­n¤£­nÂনª½¦V
Âনª½¦V¤]¤ñ¸û¦n¤U¤½¦¡
Q1:  weeknumµLªk ...
register313 µoªí©ó 2012-2-21 17:02


§ï¦¨ª½¦¡¨Ã¥[»²§UÄ榳°µ¥X¨Ó
¥u¬O·Q¬Ý¬Ý¦³¨S¦³¨ä¥L¤£¥[»²§UÄ檺¤è¦¡¥i¸Ñ
§Ú¦Û¤v¬O¥ý¥Îsumproduct¸Ñ
²{¦b·Q·Q¥[¤J»²§UÄæ¦n¹³¨Ï¥Îsumif§ó®e©ö¡A¤£ª¾¨Ï¥Î¨º¤@­Ó­pºâ·|¤ñ¸û§Ö(­ì©l¤å¥ó¨C¤éªºdata¤w¸g¤U¤F366*5­Ó¤½¦¡¤F)
§ï¦¨¦pªþ¥ó¡A¦ý¤ë¡B©uÁÙ·Q¤£¥X¤ñ¸ûÁo©úªº­pºâ¤è¦¡
§Æ±æ¤j®a«üÂI
Book1.rar (13.58 KB)

TOP

¦^´_ 6# vvcvc

©u,¤ëªº¤½¦¡«e­±¤w»¡©ú¹L¤F

§ïª½¦¡«á­×¥¿¦p¤U
B2=SUM(INDIRECT(ADDRESS(ROW()*3,COLUMN())&":"&ADDRESS(ROW()*3+2,COLUMN()),1))
B6=SUMPRODUCT((MONTH($J$2:$J$400)=ROW()-5)*K$2:K$400)

TOP

b2
=SUMPRODUCT((ROUNDUP(TEXT($J$2:$J$367,"m")/4,0)=(--RIGHT($A2,1)))*K$2:K$367)

b6
=SUMPRODUCT((TEXT($J$2:$J$367,"mmm")=$A6)*K$2:K$367)
ª¾¤§¬°ª¾¤§¡A¤£ª¾¬°¤£ª¾¡A¸Û¹ê¤]¡I

TOP

b18
=SUMPRODUCT((--(INT(($J$2:$J$367-DATE(2012,1,1))/7)+1)=(--(RIGHT($A18,2))))*(K$2:K$367))
ª¾¤§¬°ª¾¤§¡A¤£ª¾¬°¤£ª¾¡A¸Û¹ê¤]¡I

TOP

¥»©«³Ì«á¥Ñ vvcvc ©ó 2012-2-22 01:06 ½s¿è

¤S¦h¤@©Û¡A¤GºØ¤è¦¡¸Õ¹L³£¦¨¥\
¦ý³Ì«áª©­±°µ¦¨¤@¾î¤@ª½
¥ý¨Ó¬ã¨s¤G¦ìªº¸Ñµª¦A¦Û¦æ­×§ï¦¨¦Û¤v»Ý­nªº
·PÁ«ü¾É

gongª©¥Dªº¤½¦¡¤¤­n¤p¤p­×§ï¤@­Ó¼Æ¦r¡A¤@©u¥u¦³3­Ó¤ë¡AÀ³¸Ó­n°£¥H3¤~¹ï
b2
=SUMPRODUCT((ROUNDUP(TEXT($J$2:$J$367,"m")/3,0)=(--RIGHT($A2,1)))*K$2:K$367)

TOP

        ÀR«ä¦Û¦b : ª¾ÃÑ­n¥Î¤ßÅé·|¡A¤~¯àÅܦ¨¦Û¤vªº´¼¼z¡C
ªð¦^¦Cªí ¤W¤@¥DÃD