¿¢¼¿±³½Ç
NETWORKDAYS ÇÔ¼ö
=NETWORKDAYS(start_date, end_date, [holidays])
NETWORKDAYS ÇÔ¼ö´Â ½ÃÀÛÀÏ°ú Á¾·áÀÏ»çÀÌ¿¡ ÁÖ¸»(Åä,ÀÏ) ¹× °øÈÞÀÏÀ» Á¦¿ÜÇÑ Àüü ÀÛ¾÷Àϼö¸¦ ±¸ÇÒ¼ö ÀÖ´Â ÇÔ¼öÀÔ´Ï´Ù.
¡Ø Àμö¼³¸í
start_date : ÀÛ¾÷ ½ÃÀÛÀÏ end_date : ÀÛ¾÷ Á¾·áÀÏ holidays : °øÈÞÀÏÀÚÀÇ ¸ñ·Ï |
¡Ø ¾Æ·¡ Á÷¿øº° ÀÏ´çÁö±Þ°ü¸®Ç¥¸¦ º¸°í NETWORKDAYS ÇÔ¼ö¸¦ ÀÌ¿ëÇØ °øÀ¯ÀÏÀ» Á¦¿ÜÇÑ ±Ù¹«Àϼö¸¦ ±¸ÇÑ µÚ
Á÷¿øº° ÀÏ´ç±Ý¾×À» ±¸Çغ¸¼¼¿ä. (´Ü, ±Ý¾× = ±Ù¹«Àϼö X ÀÏ´ç)
¸ÕÀú ±èÁøÈ£ Á÷¿øÀÇ ±Ù¹«Àϼö¸¦ ±¸Çغ¸¸é ½ÃÀÛÀÏÀº 2014-10-03 ¼¿ÀÎ C4,
Á¾·áÀÏÀº 2014-11-28 ¼¿ÀÎ D4 ¶ó´Â °ÍÀ» ¾Ë ¼ö ÀÖ½À´Ï´Ù.
¶ÇÇÑ ±Ù¹«Á¦¿ÜÀÏ(°øÈÞÀÏ)ÀÎ ³¯Â¥´Â 2014-10-03, 2014-10-09 ¼¿ À̹ǷΠC9:C10ÀÇ ¹üÀ§·Î Àâ¾Æ ÁÙ ¼ö ÀÖ½À´Ï´Ù.
ÀÌ°ÍÀ» ¼ö½Ä¿¡ ´ëÀÔÇÏ¿© E4¼¿¿¡ »ðÀÔÇØÁÝ´Ï´Ù.
À̶§ µå·¡±×Çؼ ¼ö½ÄÀ» º¹»çÇϱâ À§ÇÏ¿© C9:C10 ÀÇ ¹üÀ§´Â Àý´ëÂüÁ¶·Î °íÁ¤½ÃÄÑÁÝ´Ï´Ù.
=NETWORKDAYS(C4, D4, $C$9:$C$10)
±×µÚ¿¡ E4¼¿ ºÎÅÍ E6¼¿±îÁö µå·¡±× ÇØÁÝ´Ï´Ù.
±Ý¾×ÀÇ °æ¿ì¿¡´Â ±Ù¹«Àϼö °öÇϱâ ÀÏ´çÀ̹ǷΠ=E4*F4 ¼ö½ÄÀ» G4¼¿¿¡ ´ëÀÔÇØÁÖ°í G6±îÁö µå·¡±× ÇØÁÖ¸é,
¾Æ·¡¿Í °°Àº °á°ú°ªÀ» ¾òÀ» ¼ö ÀÖ½À´Ï´Ù.