OfficeTutor.com
Home ·Î±×ÀΠȸ¿ø°¡ÀÔ °í°´¼¾ÅÍ »çÀÌÆ®¸Ê
½ÃÀÛÆäÀÌÁö¼³Á¤ Áñ°Üã±âÃß°¡
¹è¿òÅÍ ³ª´®ÅÍ ±³À° MY¿ÀÆ©
 
¡¡ Home > ¹è¿òÅÍ > ¹«·á°­ÁÂ
¡¡

¡¡


QA¸¦ ÅëÇØ º» È¿À²ÀûÀÎ Å×ÀÌºí ±¸¼º ¿¹Á¦ #2

2) ±âº»Å°¸¦ ã½À´Ï´Ù.
±âº» Å°´Â ·¹ÄÚµå ´ÜÀ§·Î ±¸ºÐÀÌ °¡´ÉÇÏ°Ô Çϱâ À§ÇØ »ç¿ëÇÕ´Ï´Ù. °ü°èÇü µ¥ÀÌÅͺ£À̽º´Â ·¹Äڵ庰·Î °¢°¢ ±¸º°ÀÌ µÇ¾î¾ß ÇÕ´Ï´Ù. ±×·¯³ª µÎ Å×ÀÌºí ¸ðµÎ ÇϳªÀÇ Çʵ常À¸·Î´Â ·¹ÄÚµå Çϳª Çϳª¸¦ °íÀ¯ÇÏ°Ô ±¸º°ÇÒ ¼ö ¾ø±º¿ä.
±×·¸´Ù¸é ´ÙÁß ÇÊµå ±âº» Å°¸¦ ¸¸µé¾î¾ß ÇÕ´Ï´Ù. ±×·¯³ª ¼ÓµµÀÇ ¹®Á¦¸¦ °¡Á®¿À¹Ç·Î ½ÅÁßÇØ¾ß ÇÕ´Ï´Ù.
´ÙÁß ÇÊµå ±âº» Å°¸¦ ¿î¿µÇØ¾ß ÇÑ´Ù¸é Å×À̺íÀ» ºÐ¸®ÇÏ´Â °ÍÀ» °í·ÁÇØ¾ß ÇÕ´Ï´Ù. 
ºÐ¸®ÇÑ´Ù¸é µÚ¿¡ ¾ð±ÞÇÑ Á¤±ÔÈ­ Å×À̺íÀÇ ³»¿ë°ú °°ÀÌ ºÐ¸®µË´Ï´Ù.
¸¸¾à ºÐ¸®ÇÏÁö ¾Ê°Ú´Ù¸é ±×³É ÀϷùøÈ£ ±âº» Å°¸¦ ÀÌ¿ëÇÏ´Â °ÍÀÌ ÁÁÀ» °Í °°½À´Ï´Ù.

Áֹεî·Ï¹øÈ£ Çʵå´Â Ãß°¡ÇÏÁö ¾Ê°í ±âÁ¸ Å×À̺íÀ» º¯°æÇÏ¸é ¾Æ·¡¿Í °°°Ú½À´Ï´Ù.

 ÀϷùøÈ£ »ç¹ø ¼º¸í  ¹ß·ÉÀÏ  ºÎ¼­  ¹ß·É»çÇ×
1 94-1 È«±æµ¿  94-08-08  »ç¹«¿ø  ÀÓÁ÷
2 94-1 È«±æµ¿  95-01-30 »ç¹«¿ø  ÅðÁ÷
3 94-1 È«±æµ¿  96-08-05 °æ¸®  ÀÓÁ÷
4 94-1 È«±æµ¿  97-09-30 °æ¸®  ÅðÁ÷

3) ¿ì¸®°¡ ¸ñÀûÇÏ°íÀÚ ÇÏ´Â ±â°£À» »êÁ¤Çϴµ¥ À־ ¾Æ·¡ Å×À̺íÀ» °¡Áö°í »ó´çÇÑ °ï¶õÇÔÀ» ´À³¥ ¼ö ÀÖ½À´Ï´Ù. ¹ß·ÉÀÏ°ú ¸¸·áÀÏ µÎ Çʵ带 ÀÌ¿ëÇÏ¸é °£´ÜÇÒ °Ì´Ï´Ù.

¸¸¾à Å×À̺íÀÌ ´ÙÀ½°ú °°ÀÌ ¸¸µé¾îÁ³´Ù¸é ¾î¶³±î¿ä? 
±â°£ °è»êÀº ÈξÀ ½¬¿öÁö¸ç, Àλç»óȲÀÌ ÈξÀ Àϸñ¿ä¿¬ÇØÁý´Ï´Ù.

ÀϷùøÈ£ »ç¹ø ¼º¸í ¹ß·ÉÀÏ ¸¸·áÀÏ ºÎ¼­
1 94-1 È«±æµ¿ 94-08-08 95-01-30 »ç¹«¿ø
3 94-1 È«±æµ¿  96-08-05 97-09-30  »ç¹«¿ø 

±×·¯³ª ÀÏ´Ü Áú¹®ÀÚ°¡ ÀÛ¼ºÇÑ ÀÚ·áÇüÅ·Π±â°£À» »êÁ¤ÇØ º¸µµ·Ï ÇÏ°Ú½À´Ï´Ù. À̰͵µ ÁÁÀº °øºÎ°¡ µÇ°Ú½À´Ï´Ù.
´Ü »ç¹øÀº ÀçÀԻ縦 ÇÏ´õ¶ó°í ±âÁ¸ »ç¹øÀ» ±×´ë·Î ÀÌ¿ëÇÏ¿© °³ÀÎ´ç ¿ÀÁ÷ Çϳª¸¸ ºÎ¿©µÈ´Ù°í °¡Á¤ÇÕ´Ï´Ù.

»ç¹ø ¼º¸í ¹ß·ÉÀÏ ºÎ¼­ ¹ß·É»çÇ×
94-1 È«±æµ¿ 94-08-08 »ç¹«¿ø ÀÓÁ÷
94-1 È«±æµ¿ 95-01-30  »ç¹«¿ø ÅðÁ÷
94-1 È«±æµ¿ 96-08-05 °æ¸®  ÀÓÁ÷
94-1 È«±æµ¿ 97-09-30 °æ¸®  ÅðÁ÷

´ÙÀ½Àº °è»êµÈ °á°úÀÔ´Ï´Ù.
ÀÌ·¯ÇÑ °á°ú¸¦ °è»êÇϱâ À§ÇÏ¿© ÁúÀÇÅ×ÀÌºí¿¡¼­ °è»êÇʵ带 ¸¸µé¾î »ç¿ëÇϴµ¥ °è»ê °ªÀ» »ç¿ëÀÚ Á¤ÀÇÇÔ¼ö¸¦ ¸¸µé¾î °è»êÇÕ´Ï´Ù.

01-02.gif(37827¹ÙÀÌÆ®)

±Ù¹«±â°£À» »êÁ¤ÇÏ´Â »ç¿ëÀÚ Á¤ÀÇÇÔ¼öÀÔ´Ï´Ù.

Function QuitDate(ÀÓÁ÷ÀÏ As Date, »ç¹ø As String, _
     Optional ¿øÇϴ°ª As Integer = 1, _
     Optional ¿øÇÏ´ÂÇü½Ä As Integer = 1) As Variant

Dim strCriteria As String
Dim ret As Variant

     ÀÓÁ÷ÀÏ ÀÌÈÄ¿¡¼­ ÅðÁ÷ÇÑ Ã¹ ÀڷḦ Á¶È¸ÇÑ´Ù.
     strCriteria = "³¯Â¥>=#" & ÀÓÁ÷ÀÏ & "# AND ±¸ºÐ='ÅðÁ÷' AND »ç¹ø='" & »ç¹ø & "'"

     ret = DLookup("³¯Â¥", "tblÀλçÁ¤º¸", strCriteria)

     If ¿øÇϴ°ª = 2 Then
          ret = CDate(Nz(ret, Date))

          If ¿øÇÏ´ÂÇü½Ä = 1 Then
               ret = DateDiff("d", ÀÓÁ÷ÀÏ, ret) + 1
          Else
               ret = DateDiff("m", ÀÓÁ÷ÀÏ, ret) + 1
               ret = (ret \ 12) & "³â " & (ret Mod 12) & "°³¿ù"
          End If
     End If

     QuitDate = ret

End Function

¿øÇÏ´Â ÀÛ¾÷À» Çس½À´Ï´Ù.

¡¡

¡¡

  ¸ñÂ÷ | ÀÌÀü | ´ÙÀ½¡¡ 

up ¡¡

ȸ»ç¼Ò°³ | ÀÌ¿ë¾à°ü | °³ÀÎÁ¤º¸ º¸È£Á¤Ã¥ | ȸ¿øÁ¤º¸¼öÁ¤ | ±³À°½Åû ¹× ¹®ÀÇ | À̸ÞÀϹ«´Ü¼öÁý°ÅºÎ 
   (¿ì)143-721 ¼­¿ï ±¤Áø±¸ ±¸Àǵ¿ 546-4 Å×Å©³ë¸¶Æ® 26Ãþ6È£
¢ß¿ÀÇǽºÆ©ÅÍ ¢Ï1544-4102  ´ëÇ¥ÀÌ»ç : Àü°æ¼ö
°³ÀÎÁ¤º¸°ü¸®Ã¥ÀÓÀÚ : ÀÌÈñÁø(privacy@officetutor.com)
»ç¾÷ÀÚµî·Ï¹øÈ£ 120-86-14501 Åë½ÅÆǸž÷½Å°í ±¤Áø1501È£
 
Copyright ¨Ï OfficeTutor.com ÀÌ ÆäÀÌÁöÀÇ ÀúÀÛ±ÇÀº ¢ß¿ÀÇǽºÆ©ÅÍ¿Í ÄÁÅÙÃ÷ Á¦°øÀÚ¿¡°Ô ÀÖ½À´Ï´Ù. ¹«´Ü º¹Á¦¸¦ ±ÝÇÕ´Ï´Ù.
Microsoft ¹× Office ·Î°í´Â ¹Ì±¹, ´ëÇѹα¹ ¹×/¶Ç´Â ±âŸ ±¹°¡¿¡¼­ÀÇ Microsoft Corporation µî·Ï »óÇ¥ ¶Ç´Â »óÇ¥ÀÔ´Ï´Ù.