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

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

gongª©¥DB18ªºµª®×
¤µ¦~­è¦n1/1¦bW01ªº²Ä¤@¤Ñ¡A©Ò¥HW01¦³7¤Ñ
©ú¦~W01¥u¦³6¤Ñ
³o¼Ë©ú¦~¬O¤£¬O´N­n­«·s­×§ï­pºâ¦¡?

TOP

¦^´_ 9# gong

³o­Ó¤èªk¨ÃµLªk¨ú±o¯u¥¿WEEKNUM
¥u¬O±q·í¦~1/1¤é°_ºâ¨C7¤Ñ¬°¤@©Pªººâªk
¸Õ¸Õ
B18=SUMPRODUCT(((INT(($J$2:$J$367-($J$2-WEEKDAY($J$2))-1)/7)+1)=ROW($A1))*(K$2:K$367))
¾Ç®üµL²P_¤£®¢¤U°Ý

TOP

¤£¤ÓÀ´¬°¤°»ò­n¥ý´î1¦A°£7
¤§«á«o¤S­n¦A¥[1
¥i§_¸ÑÄÀ?

TOP

¦^´_ 13# vvcvc


$J$2-WEEKDAY($J$2)±Àºâ¥X²Ä¤@©Pªº°_©l¤é´Á¥»¦~«×°_ºâ¤é
$J$2:$J$367-($J$2-WEEKDAY($J$2))·í¤é¤é´Á´î¥h¥»¦~«×°_ºâ¤é
($J$2:$J$367-($J$2-WEEKDAY($J$2))-1)±q°_ºâ¤é¦Ü·í¤é¸g¹L´X¤Ñ¡A¬°¤F»P7¾ã°£·|±o¨ì0©Ò¥H¥[1
INT(($J$2:$J$367-($J$2-WEEKDAY($J$2))-1)/7)»P7¬Û°£«á¨ú¾ã¼Æ
¾ã¼Æ¦b²Ä¤@©P·|¬°0¡A¥Ñ¦¹±Àºâ¥[1¥H«á¤~¬O¥¿½TWEEKNUM
¾Ç®üµL²P_¤£®¢¤U°Ý

TOP

¥»©«³Ì«á¥Ñ vvcvc ©ó 2012-4-7 00:24 ½s¿è

¦b³o­Ó°ÝÃDªºÀɮפ¤¨ä¹êÁÙ¦³¤@­Ó¤À­¶¥Î¨Ó¿é¤Jraw data
¦b¨C¤@¤Ñªº¸ê®Æ²Î­p®æ¤l¸Ì¥Îªº¤½¦¡¦p¤U
=SUMPRODUCT((µn°Oªí!$I$6:$I$9999=$B97)*(µn°Oªí!$N$6:$N$9999=--(LEFT(E$16,1))))
$I$6:$I$9999¬Oraw data¤¤¤é´ÁÄæ¦ì¡A¥Î¨Ó©M­pºâªº¤À­¶¤ñ¹ï¤é´Á¥H­pºâ¦¸¼Æ
¤µ¤Ñµo²{¤@­Ó°ÝÃD
¦pªG§Ú$I$6:$I$9999ªº¤é´Á¦]¦P¤@¤Ñ­nµn°O¦hµ§°O¿ý
©ó¬O¥¼¤@®æ¤@®æ¶ñ¤J¤é´Á¦Ó¬Oª½±µ±N¸ê®Æ¦V¤U©Ô
¨Ï¥Î¤W¤èªº¤½¦¡´N·|»{¤£¥X¤U©ÔªºÄæ¦ì
­Y¤@®æ¤@®æ¿é¤J«h¨S¦³°ÝÃD

³o¬O¤°»ò­ì¦]?
­ì¥»¥H¬°¦b$I$6:$I$9999«e¥[¤@­Ódatevalue§â¨º¨ÇÀx¦s®æªº­È±j­¢Âন¤é´Á¨Ó¸òBÄ檺¤é´Á¤ñ¹ï
¦ý¦ü¥G¬O¦]¬°datevalue¤£¬O°}¦C¤½¦¡¦Ó¥¢±Ñ
¦³¤°»ò¤èªk¥i¥H¸Ñ¨M¶Ü?

TOP

        ÀR«ä¦Û¦b : Ãø¦æ¯à¦æ¡AÃø±Ë¯à±Ë¡AÃø¬°¯à¬°¡A¤~¯àª@µØ¦Û§Úªº¤H®æ¡C
ªð¦^¦Cªí ¤W¤@¥DÃD