ȸ¿ø ¹æ¹® ¼ö |
8,351,586 ¸í |
Á¢¼Ó Àοø ¼ö |
965 ¸í |
| |
|
Ȩ > ¹¯°í´äÇϱâ |
[Re]°è»ê¹ýÁ» ¾Ë·Á ÁֽʽÿÀ |
¾È³çÇϼ¼¿ä.
DATEDIF ÇÔ¼ö´Â °æ°úÀÏÀ» ±¸ÇÏ´Â ÇÔ¼öÀ̹ǷÎ
+1À» ÇÏ¿© ±¸ÇÏ½Ã¸é µË´Ï´Ù.
°á°ú°¡ ³ª¿Ã ¼¿¿¡ ´ÙÀ½ ¼ö½ÄÀ» ÀÔ·ÂÇÏ½Ã¸é µË´Ï´Ù.
=DATEDIF(D4,E4+1,"Y")& "³â"&DATEDIF(D4,E4+1,"YM")&"°³¿ù"
°¨»çÇÕ´Ï´Ù.
|
ÀÛ¼ºµÈ ÄÚ¸àÆ®°¡ ¾ø½À´Ï´Ù.
|
| |
|
|
|