{"id":3071,"date":"2020-07-09T00:02:45","date_gmt":"2020-07-08T15:02:45","guid":{"rendered":"http:\/\/autooffice.co.kr\/?p=3071"},"modified":"2025-09-15T18:57:30","modified_gmt":"2025-09-15T09:57:30","slug":"datedif-%ec%99%80-vlookup%ec%9d%84-%ec%82%ac%ec%9a%a9%ed%95%b4%ec%84%9c-%ea%b1%b0%eb%9e%98%ec%b2%98-%eb%af%b8%eb%b0%a9%eb%ac%b8%ec%9d%bc%ec%88%98-%ea%b3%84%ec%82%b0%ed%95%98%ea%b8%b0","status":"publish","type":"post","link":"https:\/\/www.autooffice.co.kr\/en\/blog\/2020\/07\/09\/datedif-%ec%99%80-vlookup%ec%9d%84-%ec%82%ac%ec%9a%a9%ed%95%b4%ec%84%9c-%ea%b1%b0%eb%9e%98%ec%b2%98-%eb%af%b8%eb%b0%a9%eb%ac%b8%ec%9d%bc%ec%88%98-%ea%b3%84%ec%82%b0%ed%95%98%ea%b8%b0\/","title":{"rendered":"\uad6c\uae00\uc2dc\ud2b8 QUERY: DATEDIF \uc640 VLOOKUP\uc744 \uc0ac\uc6a9\ud574\uc11c \uac70\ub798\ucc98 \ubbf8\ubc29\ubb38\uc77c\uc218 \uacc4\uc0b0\ud558\uae30"},"content":{"rendered":"\n<p>\uc601\uc5c5\uc774 \uc911\uc2ec\uc774 \ub418\ub294 \uc0b0\uc5c5\uc5d0 \uc885\uc0ac\ud558\uace0 \uacc4\uc2dc\ub2e4\uba74, \uac70\ub798\ucc98\uc5d0 \uc5b8\uc81c \uc5f0\ub77d\ud588\uace0 \ubc29\ubb38\ud588\ub294\uc9c0\ub97c \uae30\ub85d\uc73c\ub85c \ub0a8\uaca8\ub450\uba74\uc11c \uc5b8\uc81c\ucbe4 \ub2e4\uc2dc \ubc29\ubb38\ud558\uba74 \uc88b\uc744\uc9c0 \uccb4\ud06c\ud574\uc57c\ud560 \ud544\uc694\uc131\uc774 \uc788\uc73c\uc2dc\uc8e0? <\/p>\n\n\n\n<p>\uc601\uc5c5\uc77c\uc9c0\ub97c \uc791\uc131\ud558\uba74, \uc790\ub3d9\uc73c\ub85c \uac70\ub798\ucc98 \ubaa9\ub85d\uc5d0 \ucd5c\uc885\ubc29\ubb38\uc77c\uc790 \ub610\ub294 \ubbf8\ubc29\ubb38\uc77c\uc218\ub97c \ud45c\uc2dc\ud558\ub3c4\ub85d \ub9cc\ub4e4 \uc218 \uc788\uc2b5\ub2c8\ub2e4. <\/p>\n\n\n\n<h4 class=\"gb-headline gb-headline-b2003faf\">datedif \uc640 vlookup\uc744 \uc0ac\uc6a9\ud574\uc11c \ud45c\uc2dc\ud558\ub294 \ubc29\ubc95\uc744 \uc54c\uc544\ubcf4\uaca0\uc2b5\ub2c8\ub2e4. <\/h4>\n\n\n\n<p>\uc77c\ubc18\uc801\uc73c\ub85c \uc601\uc5c5\uc77c\uc9c0\ub97c \uc791\uc131\ud558\ub294 \uc2dc\ud2b8\uc640 \uac70\ub798\ucc98 \uc2dc\ud2b8\ub294 \ub530\ub85c \uad00\ub9ac\ud558\ub294\ub370, \uc124\uba85\uc744 \uac04\uacb0\ud558\uac8c \ud558\uae30 \uc704\ud574\uc11c \ud55c \ud398\uc774\uc9c0\uc5d0\uc11c \uc791\uc5c5\ud558\uaca0\uc2b5\ub2c8\ub2e4. <\/p>\n\n\n\n<p>\uc67c\ucabd\uc5d0\ub294 \uc601\uc5c5\uc77c\uc9c0, \uc624\ub978\ucabd\uc5d0\ub294 \uac70\ub798\ucc98 \uc2dc\ud2b8\ub77c\uace0 \ud558\uaca0\uc2b5\ub2c8\ub2e4. \ub2e4\ub978 \uc815\ubcf4\ub4e4\uc774 \uc788\uc744 \uc218 \uc788\uc9c0\ub9cc \uc124\uba85\uc758 \ucd08\uc810\uc778 \uc601\uc5c5\uc77c\uc790\uc640 \ubbf8\ubc29\ubb38\uc77c\uc218\ub9cc \uc368\ub450\uc5c8\uc2b5\ub2c8\ub2e4. \uc601\uc5c5\uc77c\uc9c0\uc5d0\ub294 \uc601\uc5c5\ub0b4\uc6a9, \ub2f4\ub2f9\uc790 \ub4f1\uc774 \ub4e4\uc5b4\uac08 \uc218 \uc788\uace0, \uac70\ub798\ucc98\uc2dc\ud2b8\uc5d0\ub294 \uac70\ub798\ucc98 \uc804\ud654\ubc88\ud638, \ub2f4\ub2f9\uc790\uba85, \uc8fc\uc18c, \uc0ac\uc5c5\uc790\ub4f1\ub85d\ubc88\ud638 \ub4f1 \ub2e4\uc591\ud558\uac8c \ub4e4\uc5b4\uac08 \uc218 \uc788\uaca0\uc9c0\uc694. <\/p>\n\n\n\n<p>\uc774\uc81c \uac70\ub798\ucc98\uc2dc\ud2b8(\ud654\uba74\uc758 \uc624\ub978\ucabd \ubd80\ubd84)\uc5d0\uc11c \ubbf8\ubc29\ubb38\uc77c\uc218\ub97c \uacc4\uc0b0\ud558\ub294 \ubc29\ubc95\uc744 \uc0b4\ud3b4\ubcf4\uaca0\uc2b5\ub2c8\ub2e4. <\/p>\n\n\n\n<figure class=\"wp-block-image size-large\"><img loading=\"lazy\" decoding=\"async\" width=\"852\" height=\"440\" src=\"http:\/\/autooffice.co.kr\/wp\/wp-content\/uploads\/2020\/07\/image-29.png\" alt=\"\ubbf8\ubc29\ubb38\uc77c\uc218\" class=\"wp-image-3074\" srcset=\"https:\/\/www.autooffice.co.kr\/wp\/wp-content\/uploads\/2020\/07\/image-29.png 852w, https:\/\/www.autooffice.co.kr\/wp\/wp-content\/uploads\/2020\/07\/image-29-300x155.png 300w, https:\/\/www.autooffice.co.kr\/wp\/wp-content\/uploads\/2020\/07\/image-29-768x397.png 768w\" sizes=\"auto, (max-width: 852px) 100vw, 852px\" \/><\/figure>\n\n\n\n<p>\uc67c\ucabd\uc758 \uc601\uc5c5\uc77c\uc9c0\uc5d0\ub294 \uacc4\uc18d \uc601\uc5c5\uc77c\uc790\uc640 \uac70\ub798\ucc98\uac00 \ub204\uc801\uc774 \ub429\ub2c8\ub2e4.  <\/p>\n\n\n\n<h5 class=\"wp-block-heading\">\ubbf8\ubc29\ubb38\uc77c\uc218\ub97c \uacc4\uc0b0\ud558\uae30 \uc704\ud574\uc11c\ub294 \ud2b9\uc815 \uac70\ub798\ucc98\uc758 \uac00\uc7a5 \ub9c8\uc9c0\ub9c9 \uc601\uc5c5\uc77c\uc790\ub97c \ucc3e\uc544\uc11c \uc624\ub298\uacfc \ube44\uad50\ud574\uc8fc\uc5b4\uc57c \ud569\ub2c8\ub2e4. <\/h5>\n\n\n\n<p>\uac00\uc7a5 \ub9c8\uc9c0\ub9c9 \uc601\uc5c5\uc77c\uc790\ub97c \ucc3e\ub294 \uac83\uc774 \ud0a4\uc778\ub370, \ub2e8\uc21c\ud788 VLOOKUP\ub9cc \uc0ac\uc6a9\ud574\uc11c\ub294  \uc6d0\ud558\ub294 \uac12\uc744 \ucc3e\uc744 \uc218 \uc5c6\uc2b5\ub2c8\ub2e4. <\/p>\n\n\n\n<p>\uc608\ub97c \ub4e4\uc5b4 VLOOKUP\uc758 \uc815\ub82c\uc744 FALSE\ub85c \ud574\ubcf4\uaca0\uc2b5\ub2c8\ub2e4. <\/p>\n\n\n\n<p>\uac70\ub798\ucc981\uc758 \uc601\uc5c5\uc77c\uc790\uac00 3\uac1c\uac00 \uc788\ub294\ub370, \uadf8\uc911\uc5d0 \uac00\uc7a5 \uc704\uc758 \uac12\uc744 \uac00\uc838\uc635\ub2c8\ub2e4. <\/p>\n\n\n\n<figure class=\"wp-block-image size-large\"><img loading=\"lazy\" decoding=\"async\" width=\"1024\" height=\"652\" src=\"http:\/\/autooffice.co.kr\/wp\/wp-content\/uploads\/2020\/07\/image-30-1024x652.png\" alt=\"VLOOKUP FALSE\" class=\"wp-image-3075\" srcset=\"https:\/\/www.autooffice.co.kr\/wp\/wp-content\/uploads\/2020\/07\/image-30-1024x652.png 1024w, https:\/\/www.autooffice.co.kr\/wp\/wp-content\/uploads\/2020\/07\/image-30-300x191.png 300w, https:\/\/www.autooffice.co.kr\/wp\/wp-content\/uploads\/2020\/07\/image-30-768x489.png 768w, https:\/\/www.autooffice.co.kr\/wp\/wp-content\/uploads\/2020\/07\/image-30.png 1032w\" sizes=\"auto, (max-width: 1024px) 100vw, 1024px\" \/><\/figure>\n\n\n\n<p>\uadf8\ub807\ub2e4\uace0 \uc815\ub82c\uc744 TRUE \ud55c\ub2e4\uace0 \ud574\uc11c, \uc62c\ubc14\ub978 \uac12\uc744 \ucc3e\uc544\uc8fc\uc9c0\ub3c4 \uc54a\uc2b5\ub2c8\ub2e4. \uc560\ub9e4\ud558\uac8c \uc911\uac04\uc5d0 \uc788\ub294 \uac12\uc744 \uac00\uc838\uc654\uc2b5\ub2c8\ub2e4. \uc774\ub807\uac8c \uac00\uc838\uc624\ub294 \uc774\uc720\ub294 TRUE\ub294 VLOOKUP \uc5d0\uc11c \uccab\ubc88\uc9f8 \uc5f4\uc774 \uc815\ub82c\uc774 \ub418\uc5b4\uc788\uc744 \ub54c\uc5d0 \uc0ac\uc6a9\ud558\ub294 \uac83\uc774\uae30 \ub54c\ubb38\uc785\ub2c8\ub2e4. <\/p>\n\n\n\n<figure class=\"wp-block-image size-large\"><img loading=\"lazy\" decoding=\"async\" width=\"1021\" height=\"659\" src=\"http:\/\/autooffice.co.kr\/wp\/wp-content\/uploads\/2020\/07\/image-31.png\" alt=\"VLOOKUP TRUE\" class=\"wp-image-3076\" srcset=\"https:\/\/www.autooffice.co.kr\/wp\/wp-content\/uploads\/2020\/07\/image-31.png 1021w, https:\/\/www.autooffice.co.kr\/wp\/wp-content\/uploads\/2020\/07\/image-31-300x194.png 300w, https:\/\/www.autooffice.co.kr\/wp\/wp-content\/uploads\/2020\/07\/image-31-768x496.png 768w\" sizes=\"auto, (max-width: 1021px) 100vw, 1021px\" \/><\/figure>\n\n\n\n<h4 class=\"wp-block-heading\">\ub2e8\uc21c\ud788 VLOOKUP\uc73c\ub85c \ub9c8\uc9c0\ub9c9 \uc601\uc5c5\uc77c\uc790\ub97c \ucc3e\uc744 \uc218 \uc5c6\uc5c8\ub294\ub370, \uc5ec\uae30\uc11c QUERY\uac00 \ud544\uc694\ud558\uac8c \ub429\ub2c8\ub2e4. <\/h4>\n\n\n\n<p>\uc774\uc81c \uc606\uc5d0 QUERY\ub85c \ubaa9\ub85d\uc744 \ud558\ub098 \ub9cc\ub4e4\ud150\ub370, \uac70\ub798\ucc98\ub97c \uccab\ubc88\uc9f8 \uc5f4\ub85c, \uc601\uc5c5\uc77c\uc790\ub97c \ub450\ubc88\uc9f8 \uc5f4\ub85c \ubd88\ub7ec\uc624\uba74\uc11c \uac70\ub798\ucc98\uc640 \ubc29\ubb38\uc77c\uc790\ub97c \uc815\ub82c\ud574\ubcf4\uaca0\uc2b5\ub2c8\ub2e4. <\/p>\n\n\n\n<pre class=\"wp-block-verse\">=QUERY(A1:B11,\"SELECT B, A\",1)<\/pre>\n\n\n\n<p>A1:B11 \uc5d0\uc11c \uc5f4\uc744 \uc120\ud0dd\ud558\ub294\ub370, \uac70\ub798\ucc98\ub97c \uba3c\uc800 \ud45c\uc2dc\ud558\uace0 \uc601\uc5c5\uc77c\uc790\ub97c \ub2e4\uc74c \uc5f4\uc5d0 \ud45c\uc2dc\ud560 \uac83\uc774\uae30 \ub54c\ubb38\uc5d0 SELECT B, A \ub85c \uc368\uc90d\ub2c8\ub2e4. \uc27c\ud45c \ub4a4\uc758 1\uc740 \uccab\ubc88\uc9f8 \ud589\uc744 \ub77c\ubca8\ub85c \uc4f0\uaca0\ub2e4\ub294 \uc758\ubbf8\uc785\ub2c8\ub2e4. <\/p>\n\n\n\n<p>QUERY\uc5d0 \ub530\ub77c \ub370\uc774\ud130\ub294 B\uc640 A\uc5f4\uc744 \uadf8\ub300\ub85c \uac00\uc838\uc624\uac8c \ub429\ub2c8\ub2e4. \uadf8\ub7ec\uba74 VLOOKUP\uc744 \uc2dc\ub3c4\ud55c \uac83\uacfc \ub2e4\ub97c \ubc14\uac00 \uc5c6\uaca0\uc8e0. <\/p>\n\n\n\n<figure class=\"wp-block-image size-large\"><img loading=\"lazy\" decoding=\"async\" width=\"348\" height=\"414\" src=\"http:\/\/autooffice.co.kr\/wp\/wp-content\/uploads\/2020\/07\/image-33.png\" alt=\"QUERY\" class=\"wp-image-3078\" srcset=\"https:\/\/www.autooffice.co.kr\/wp\/wp-content\/uploads\/2020\/07\/image-33.png 348w, https:\/\/www.autooffice.co.kr\/wp\/wp-content\/uploads\/2020\/07\/image-33-252x300.png 252w\" sizes=\"auto, (max-width: 348px) 100vw, 348px\" \/><\/figure>\n\n\n\n<p>\uc774\uc81c \ubcf4\uae30 \uc88b\uac8c, \uac70\ub798\ucc98\ub85c \uba3c\uc800 \uc815\ub82c\ud558\uace0, \uc601\uc5c5\uc77c\uc790\ub85c \uc815\ub82c\ud558\uae30 \uc704\ud574\uc11c QUERY\uc5d0 ORDER BY \ub97c \uc801\uc6a9\ud569\ub2c8\ub2e4. <\/p>\n\n\n\n<pre class=\"wp-block-preformatted\">=QUERY(A1:B11,\"SELECT B, A ORDER BY B, A DESC\",1)<\/pre>\n\n\n\n<p>DESC\ub97c \uc368\uc8fc\uba74 \ub0b4\ub9bc\ucc28\uc21c\uc73c\ub85c \uc815\ub82c\uc774 \ub429\ub2c8\ub2e4. \uac00\uc7a5 \ub192\uc740 \uc22b\uc790 \ub610\ub294 \ub0a0\uc9dc\ubd80\ud130 \ub0ae\uc544\uc9c0\ub294 \uc21c\uc11c\uc785\ub2c8\ub2e4. (ASC\ub97c \uc368\uc8fc\uba74 \uc624\ub984\ucc28\uc21c\uc73c\ub85c \uc815\ub82c\uc774 \ub429\ub2c8\ub2e4. )<\/p>\n\n\n\n<p>\uc774\uc81c \uacb0\uacfc\uac00 \uc544\ub798\uc640 \uac19\uc774 \ub098\uc635\ub2c8\ub2e4. \uac70\ub798\ucc98 1\uc758 \uc601\uc5c5\uc77c\uc790\uac00 \ub0b4\ub9bc\ucc28\uc21c\uc73c\ub85c \uc815\ub82c\uc774 \ub418\uc5c8\uc2b5\ub2c8\ub2e4. <\/p>\n\n\n\n<figure class=\"wp-block-image size-large\"><img loading=\"lazy\" decoding=\"async\" width=\"1024\" height=\"444\" src=\"http:\/\/autooffice.co.kr\/wp\/wp-content\/uploads\/2020\/07\/image-32-1024x444.png\" alt=\"QUERY ORDER BY \" class=\"wp-image-3077\" srcset=\"https:\/\/www.autooffice.co.kr\/wp\/wp-content\/uploads\/2020\/07\/image-32-1024x444.png 1024w, https:\/\/www.autooffice.co.kr\/wp\/wp-content\/uploads\/2020\/07\/image-32-300x130.png 300w, https:\/\/www.autooffice.co.kr\/wp\/wp-content\/uploads\/2020\/07\/image-32-768x333.png 768w, https:\/\/www.autooffice.co.kr\/wp\/wp-content\/uploads\/2020\/07\/image-32-1536x666.png 1536w, https:\/\/www.autooffice.co.kr\/wp\/wp-content\/uploads\/2020\/07\/image-32.png 1546w\" sizes=\"auto, (max-width: 1024px) 100vw, 1024px\" \/><\/figure>\n\n\n\n<p>\uc774\uc81c QUERY \uacb0\uacfc\ub97c VLOOKUP \ud574\uc11c \uc6d0\ud558\ub294 \ub9c8\uc9c0\ub9c9 \uc601\uc5c5\uc77c\uc790\ub97c \uac00\uc838\uc62c\ud150\ub370\uc694. <\/p>\n\n\n\n<p>VLOOKUP\uc744 \uc801\uc6a9\ud560 \ub54c\uc5d0 \ubc94\uc704\ub294 \uc774\ub984\uc744 \uc9c0\uc815\ud558\ub294 \uac83\uc774 \ud3b8\ud569\ub2c8\ub2e4. VLOOKUP\uc744 \ubcf5\uc0ac\ud574\uc11c \ubd99\uc5ec\ub123\uc744 \ub54c\uc5d0 \uc0c1\ub300\ucc38\uc870\uc600\ub2e4\uac00 \ubb38\uc81c\uac00 \uc0dd\uae30\ub294 \uc77c\uc744 \ubbf8\uc5f0\uc5d0 \ubc29\uc9c0\ud560 \uc218 \uc788\uace0, \ud6c4\uc5d0 \ubc94\uc704\ub97c \ubc14\uafc0 \ub54c\uc5d0\ub3c4 \uc720\uc6a9\ud569\ub2c8\ub2e4. <\/p>\n\n\n\n<p>H2:I11 \uae4c\uc9c0\uc758 \ubc94\uc704\uc5d0 \ubbf8\ubc29\ubb38\uc77c\uc218\ub77c\ub294 \uc774\ub984\uc744 \ucd94\uac00\ud574\uc8fc\uaca0\uc2b5\ub2c8\ub2e4. (\uc774\ub984\uc744 \ucd94\uac00\ud558\ub294 \ubc29\ubc95\uc740 <a aria-label=\"undefined (\uc0c8\ud0ed\uc73c\ub85c \uc5f4\uae30)\" href=\"http:\/\/autooffice.co.kr\/spreadsheet\/%ec%85%80%ec%97%90-%ec%a7%80%ec%a0%95%eb%90%9c-%ea%b0%92%eb%a7%8c-%ec%84%a0%ed%83%9d%ed%95%a0-%ec%88%98-%ec%9e%88%eb%8f%84%eb%a1%9d-%eb%a7%8c%eb%93%9c%eb%8a%94-%ec%9d%b4%eb%a6%84%ec%9d%b4\/\" target=\"_blank\" rel=\"noreferrer noopener\">\uc774\uc804 \ud3ec\uc2a4\ud2b8<\/a>\ub97c \ucc38\uc870\ud558\uc138\uc694)<\/p>\n\n\n\n<p>\uadf8\ub9ac\uace0 \uc544\uae4c VLOOKUP \uc744 \uc0ac\uc6a9\ud588\ub358 \uc140 \uc606\uc5d0 QUERY \uacb0\uacfc\ub97c VLOOKUP \ud574\ubcf4\uaca0\uc2b5\ub2c8\ub2e4. <\/p>\n\n\n\n<p>\uac00\uc7a5 \uc704\uc758 \uac12\uc744 \uc801\uc6a9\ud560 \uac83\uc774\uae30\uc5d0 FALSE\ub97c \uc0ac\uc6a9\ud569\ub2c8\ub2e4. (\ub9cc\uc57d TRUE\ub97c \uc801\uc6a9\ud558\uba74 \uac00\uc7a5 \ube60\ub978 \uc601\uc5c5\uc77c\uc790\ub97c \ud45c\uc2dc\ud558\uac8c \ub418\uaca0\uc8e0)<\/p>\n\n\n\n<pre class=\"wp-block-verse\">=vlookup(D2,\ubbf8\ubc29\ubb38\uc77c\uc218,2,false)<\/pre>\n\n\n\n<figure class=\"wp-block-image size-large\"><img loading=\"lazy\" decoding=\"async\" width=\"1024\" height=\"433\" src=\"http:\/\/autooffice.co.kr\/wp\/wp-content\/uploads\/2020\/07\/image-34-1024x433.png\" alt=\"QUERY VLOOKUP\" class=\"wp-image-3079\" srcset=\"https:\/\/www.autooffice.co.kr\/wp\/wp-content\/uploads\/2020\/07\/image-34-1024x433.png 1024w, https:\/\/www.autooffice.co.kr\/wp\/wp-content\/uploads\/2020\/07\/image-34-300x127.png 300w, https:\/\/www.autooffice.co.kr\/wp\/wp-content\/uploads\/2020\/07\/image-34-768x324.png 768w, https:\/\/www.autooffice.co.kr\/wp\/wp-content\/uploads\/2020\/07\/image-34-1536x649.png 1536w, https:\/\/www.autooffice.co.kr\/wp\/wp-content\/uploads\/2020\/07\/image-34.png 1638w\" sizes=\"auto, (max-width: 1024px) 100vw, 1024px\" \/><\/figure>\n\n\n\n<h4 class=\"gb-headline gb-headline-fcd67172\">QUERY\uc640 VLOOKUP\uc744 \uc0ac\uc6a9\ud574\uc11c \uc6d0\ud558\ub294 \ub9c8\uc9c0\ub9c9 \uc601\uc5c5\uc77c\uc790\ub97c \uad6c\ud588\uc2b5\ub2c8\ub2e4. <\/h4>\n\n\n\n<p>\uadf8\ub7fc \uc774\uc81c, \uc624\ub298\uacfc \ub9c8\uc9c0\ub9c9 \uc601\uc5c5\uc77c\uc790\uc640\uc758 \ucc28\uc774\ub97c \uad6c\ud574\uc11c \ubbf8\ubc29\ubb38\uc77c\uc218\ub97c \uacc4\uc0b0\ud574\uc57c\uaca0\uc9c0\uc694. <\/p>\n\n\n\n<p>datedif \ud568\uc218\ub294 \ub0a0\uc9dc\uc758 \ucc28\uc774\ub97c \uacc4\uc0b0\ud574\uc8fc\ub294\ub370, \uc2dc\uc791\uc77c, \uc885\ub8cc\uc77c, \ub2e8\uc704\ub97c \ub123\uac8c \ub418\uc5b4\uc788\uc2b5\ub2c8\ub2e4.<\/p>\n\n\n\n<p>\uc2dc\uc791\uc77c\uc5d0\ub294 query-vlookup \uc73c\ub85c \uc5bb\uc740 \uacb0\uacfc\ub97c \ub123\uace0, \uc885\ub8cc\uc77c\uc740 today()\ub85c \uc624\ub298\uc744 \ub123\uc5b4\uc90d\ub2c8\ub2e4. \ub2e8\uc704\ub294 &#8220;D&#8221;\ub77c\uace0 \uc4f0\uba74 \uc77c\uc744 \uacc4\uc0b0\ud569\ub2c8\ub2e4. \uc218\uc2dd\uc740 \ub2e4\uc74c\uacfc \uac19\uc2b5\ub2c8\ub2e4.  <\/p>\n\n\n\n<pre class=\"wp-block-verse\">=datedif(vlookup(D2,\ubbf8\ubc29\ubb38\uc77c\uc218,2,false),today(),\"D\")<\/pre>\n\n\n\n<p>\uc774\uc81c \uc544\ub798\uc640 \uac19\uc740 \uacb0\uacfc\ub97c \uc5bb\uac8c \ub429\ub2c8\ub2e4. \uc624\ub298(7\/8) \uc601\uc5c5\ud55c \uac70\ub798\ucc981\uc758 \uacbd\uc6b0\uc5d0 \ubbf8\ubc29\ubb38\uc77c\uc218\uac00 0\ub85c \uc815\ud655\ud558\uac8c \ub098\uc635\ub2c8\ub2e4.  <\/p>\n\n\n\n<figure class=\"wp-block-image size-large\"><img loading=\"lazy\" decoding=\"async\" width=\"1024\" height=\"444\" src=\"http:\/\/autooffice.co.kr\/wp\/wp-content\/uploads\/2020\/07\/image-35-1024x444.png\" alt=\"\ubbf8\ubc29\ubb38\uc77c\uc218 \uacb0\uacfc\" class=\"wp-image-3080\" srcset=\"https:\/\/www.autooffice.co.kr\/wp\/wp-content\/uploads\/2020\/07\/image-35-1024x444.png 1024w, https:\/\/www.autooffice.co.kr\/wp\/wp-content\/uploads\/2020\/07\/image-35-300x130.png 300w, https:\/\/www.autooffice.co.kr\/wp\/wp-content\/uploads\/2020\/07\/image-35-768x333.png 768w, https:\/\/www.autooffice.co.kr\/wp\/wp-content\/uploads\/2020\/07\/image-35-1536x667.png 1536w, https:\/\/www.autooffice.co.kr\/wp\/wp-content\/uploads\/2020\/07\/image-35.png 1719w\" sizes=\"auto, (max-width: 1024px) 100vw, 1024px\" \/><\/figure>\n\n\n\n<p>\uc0ac\uc9c4\uc5d0\ub294 \ucd5c\uadfc\ubc29\ubb38\uc774\ub825\uc5c6\uc74c\uc774 \ud45c\uc2dc\ub418\ub294\ub370, \ud604\uc5c5\uc5d0\uc11c\ub294 \uc774\ub807\uac8c \ud45c\uc2dc\ub418\ub294 \uac83\uc774 #N\/A\ub85c \ud45c\uc2dc\ub418\ub294 \uac83\ubcf4\ub2e4 \ud6e8\uc52c \ubcf4\uae30\uac00 \uc88b\uaca0\uc8e0? \uc774 \ubd80\ubd84\uc740 \ub2e4\uc74c\uc5d0 if\uc640 isna \ud568\uc218 \uae00\uc5d0\uc11c \ub2e4\ub8e8\ub3c4\ub85d \ud558\uaca0\uc2b5\ub2c8\ub2e4. <\/p>\n\n\n\n<hr class=\"wp-block-separator has-css-opacity\"\/>\n\n\n\n<p>\uc624\ub298\uc758 \uc0d8\ud50c\uc744 \ud655\uc778\ud574\ubcf4\uc138\uc694. PC\ub97c \uad8c\uc7a5\ub4dc\ub9bd\ub2c8\ub2e4. <\/p>\n\n\n\n<div class=\"gb-button-wrapper gb-button-wrapper-0999caec\">\n\n<a class=\"gb-button gb-button-211c14b1 button\" href=\"https:\/\/vo.la\/BXKOh\" target=\"_blank\" rel=\"noopener noreferrer\"><span class=\"button-text\">\uc0d8\ud50c \ubcf4\uae30<\/span><\/a>\n\n<\/div>\n\n\n\n<p><br><\/p>\n\n\n\n<hr class=\"wp-block-separator has-alpha-channel-opacity is-style-wide\"\/>\n\n\n\n<p><br><\/p>\n\n\n\n<figure class=\"wp-block-image size-full\"><img loading=\"lazy\" decoding=\"async\" width=\"691\" height=\"512\" src=\"https:\/\/www.autooffice.co.kr\/wp\/wp-content\/uploads\/2025\/08\/image-27.png\" alt=\"\" class=\"wp-image-17075\" srcset=\"https:\/\/www.autooffice.co.kr\/wp\/wp-content\/uploads\/2025\/08\/image-27.png 691w, https:\/\/www.autooffice.co.kr\/wp\/wp-content\/uploads\/2025\/08\/image-27-300x222.png 300w\" sizes=\"auto, (max-width: 691px) 100vw, 691px\" \/><\/figure>\n\n\n\n<h2 class=\"wp-block-heading\" id=\"aioseo-\uc5c5\ubb34-\ud6a8\uc728\uc131-200-\uc62c\ub9ac\uae30-with-autooffice\">\uc5c5\ubb34 \ud6a8\uc728\uc131 200% \uc62c\ub9ac\uae30, with autooffice<\/h2>\n\n\n\n<h2 class=\"wp-block-heading\" id=\"aioseo-\ub8e8\ucee4-\uc2a4\ud29c\ub514\uc624-\uac1c\ubc1c-\ubb38\uc758\ub294-\uad6c\uae00\ud3fc\uc744-\uc774\uc6a9\ud574\uc8fc\uc138\uc694\">\ud504\ub85c\uc81d\ud2b8 \uac1c\ubc1c \ubb38\uc758\ub294 \uad6c\uae00\ud3fc\uc744 \uc774\uc6a9\ud574\uc8fc\uc138\uc694!<\/h2>\n\n\n\n<p><\/p>\n\n\n\n<p><a href=\"https:\/\/docs.google.com\/forms\/d\/e\/1FAIpQLSc-FiMM9foF0jEAWqL7IePJTEdQ0X9asQTENOIv_3mltyq2zg\/viewform?pli=1\" target=\"_blank\" rel=\"noopener\" title=\"\">\uc624\ud1a0\uc624\ud53c\uc2a4 \ud504\ub85c\uc81d\ud2b8 \ubb38\uc758<\/a><\/p>\n\n\n\n<p><br><\/p>\n\n\n\n<p><\/p>\n","protected":false},"excerpt":{"rendered":"<p>\uc601\uc5c5\uc774 \uc911\uc2ec\uc774 \ub418\ub294 \uc0b0\uc5c5\uc5d0 \uc885\uc0ac\ud558\uace0 \uacc4\uc2dc\ub2e4\uba74, \uac70\ub798\ucc98\uc5d0 \uc5b8\uc81c \uc5f0\ub77d\ud588\uace0 \ubc29\ubb38\ud588\ub294\uc9c0\ub97c \uae30\ub85d\uc73c\ub85c \ub0a8\uaca8\ub450\uba74\uc11c \uc5b8\uc81c\ucbe4 \ub2e4\uc2dc \ubc29\ubb38\ud558\uba74 \uc88b\uc744\uc9c0 \uccb4\ud06c\ud574\uc57c\ud560 \ud544\uc694\uc131\uc774 \uc788\uc73c\uc2dc\uc8e0? \uc601\uc5c5\uc77c\uc9c0\ub97c \uc791\uc131\ud558\uba74, \uc790\ub3d9\uc73c\ub85c \uac70\ub798\ucc98 \ubaa9\ub85d\uc5d0 \ucd5c\uc885\ubc29\ubb38\uc77c\uc790 \ub610\ub294 \ubbf8\ubc29\ubb38\uc77c\uc218\ub97c \ud45c\uc2dc\ud558\ub3c4\ub85d \ub9cc\ub4e4 \uc218 \uc788\uc2b5\ub2c8\ub2e4. \uc77c\ubc18\uc801\uc73c\ub85c \uc601\uc5c5\uc77c\uc9c0\ub97c \uc791\uc131\ud558\ub294 \uc2dc\ud2b8\uc640 \uac70\ub798\ucc98 \uc2dc\ud2b8\ub294 \ub530\ub85c \uad00\ub9ac\ud558\ub294\ub370, \uc124\uba85\uc744 \uac04\uacb0\ud558\uac8c \ud558\uae30 \uc704\ud574\uc11c \ud55c \ud398\uc774\uc9c0\uc5d0\uc11c \uc791\uc5c5\ud558\uaca0\uc2b5\ub2c8\ub2e4. \uc67c\ucabd\uc5d0\ub294 \uc601\uc5c5\uc77c\uc9c0, \uc624\ub978\ucabd\uc5d0\ub294 \uac70\ub798\ucc98 \uc2dc\ud2b8\ub77c\uace0 \ud558\uaca0\uc2b5\ub2c8\ub2e4. \ub2e4\ub978 \uc815\ubcf4\ub4e4\uc774 \uc788\uc744&#8230;<\/p>\n","protected":false},"author":1,"featured_media":3080,"comment_status":"closed","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"_kad_post_transparent":"","_kad_post_title":"","_kad_post_layout":"","_kad_post_sidebar_id":"","_kad_post_content_style":"","_kad_post_vertical_padding":"","_kad_post_feature":"","_kad_post_feature_position":"","_kad_post_header":false,"_kad_post_footer":false,"footnotes":""},"categories":[5],"tags":[36,15,8],"class_list":["post-3071","post","type-post","status-publish","format-standard","has-post-thumbnail","hentry","category-spreadsheet","tag-datedif","tag-query","tag-vlookup"],"translation":{"provider":"WPGlobus","version":"3.0.2","language":"en","enabled_languages":["ko","en"],"languages":{"ko":{"title":true,"content":true,"excerpt":false},"en":{"title":false,"content":false,"excerpt":false}}},"aioseo_notices":[],"_links":{"self":[{"href":"https:\/\/www.autooffice.co.kr\/en\/wp-json\/wp\/v2\/posts\/3071","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/www.autooffice.co.kr\/en\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/www.autooffice.co.kr\/en\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/www.autooffice.co.kr\/en\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/www.autooffice.co.kr\/en\/wp-json\/wp\/v2\/comments?post=3071"}],"version-history":[{"count":2,"href":"https:\/\/www.autooffice.co.kr\/en\/wp-json\/wp\/v2\/posts\/3071\/revisions"}],"predecessor-version":[{"id":17245,"href":"https:\/\/www.autooffice.co.kr\/en\/wp-json\/wp\/v2\/posts\/3071\/revisions\/17245"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/www.autooffice.co.kr\/en\/wp-json\/wp\/v2\/media\/3080"}],"wp:attachment":[{"href":"https:\/\/www.autooffice.co.kr\/en\/wp-json\/wp\/v2\/media?parent=3071"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.autooffice.co.kr\/en\/wp-json\/wp\/v2\/categories?post=3071"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.autooffice.co.kr\/en\/wp-json\/wp\/v2\/tags?post=3071"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}