[µo°Ý] Excel 2007¦p¦ó­pºâ¬Y¤@´Á¶¡¤¤,¦³´X­Ó¬P´Á¤Ñ?

luchiencheng

1.Excel¦³­pºâworkday,¦ý§Ú¥u­n­pºâ¬P´Á¤Ñ,½Ð¤j®a±Ð§Ú,ÁÂÁÂ!
2.§Ú¥¶¤F³\¦h¤å,³£­ncheck¼W¯q¶°ªº¤ÀªRºÞ²z­û¬O§_¶}±Ò,¥i¬O§Ú§ä¤£¨ì§Úªº¼W¯q°¦¦b­þ¨à?

ANGELA

¶}©l¤é´Á¦bA1µ²§ô¤é´Á¦bA2
=SUMPRODUCT((MOD(ROW(INDIRECT("A"&A1&":A"&A2)),7)=1)*1)

2.
¥ª¤W¨¤windowsªº¶ê§Î«ö¯Ã=>«öI ©Î¥ª¤U¨¤ªºexcel¿ï¶µ=>¼W¯q¶°

JBY

¦^´_ 1# luchiencheng

¶}©l¤é´Á¦bA1

µ²§ô¤é´Á¦bA2

¤¤¶¡ªº¬P´Á¤Ñ :

=SUMPRODUCT(--(WEEKDAY(ROW(INDIRECT(A1&":"&A2)))=1))

JBY

¦^´_ 1# luchiencheng

©ÎªÌ :

=SUMPRODUCT(--(WEEKDAY(ROW(INDIRECT(A1&":"&A2)),2)=7))

JBY

¶}©l¤é´Á¦bA1µ²§ô¤é´Á¦bA2
=SUMPRODUCT((MOD(ROW(INDIRECT("A"&A1&":A"&A2)),7)=1)*1)

2.
¥ª¤W¨¤windo ...
ANGELA µoªí©ó 2012-11-5 09:57

¤½¦¡¤¤间ªº"A"¥i¥H删°£

=SUMPRODUCT((MOD(ROW(INDIRECT("A"&A1&":A"&A2)),7)=1)*1)

­×§ï :

=SUMPRODUCT((MOD(ROW(INDIRECT(A1&":"&A2)),7)=1)*1)

JBY

©ÎªÌ :

=FLOOR((A2-1)/7,1)-CEILING((A1-1)/7,1)+1

jak

¤U¦Cºô§}¦³¸Ô²Ó»¡©ú
http://isvincent.blogspot.tw/2011/11/excel-sumproduct_27.html
--
¬Oµ¹§Ú³oºØ·s¤â¥Îªº :D

ML089

=INT((A2-1)/7)-INT((A1-2)/7)

luchiencheng

ÁÂÁ¦U¦ì¤j¤j¼ö¤ß¦^´_