{"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 class=\"wp-block-paragraph\">\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 class=\"wp-block-paragraph\">\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 class=\"wp-block-paragraph\">\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 class=\"wp-block-paragraph\">\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 class=\"wp-block-paragraph\">\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 class=\"wp-block-paragraph\">\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 class=\"wp-block-paragraph\">\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 class=\"wp-block-paragraph\">\uc608\ub97c \ub4e4\uc5b4 VLOOKUP\uc758 \uc815\ub82c\uc744 FALSE\ub85c \ud574\ubcf4\uaca0\uc2b5\ub2c8\ub2e4. <\/p>\n\n\n\n<p class=\"wp-block-paragraph\">\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 class=\"wp-block-paragraph\">\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 class=\"wp-block-paragraph\">\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 class=\"wp-block-paragraph\">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 class=\"wp-block-paragraph\">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 class=\"wp-block-paragraph\">\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 class=\"wp-block-paragraph\">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 class=\"wp-block-paragraph\">\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 class=\"wp-block-paragraph\">\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 class=\"wp-block-paragraph\">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 class=\"wp-block-paragraph\">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 class=\"wp-block-paragraph\">\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 class=\"wp-block-paragraph\">\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 class=\"wp-block-paragraph\">\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 class=\"wp-block-paragraph\">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 class=\"wp-block-paragraph\">\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 class=\"wp-block-paragraph\">\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 class=\"wp-block-paragraph\">\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 class=\"wp-block-paragraph\">\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 class=\"wp-block-paragraph\"><br><\/p>\n\n\n\n<hr class=\"wp-block-separator has-alpha-channel-opacity is-style-wide\"\/>\n\n\n\n<p class=\"wp-block-paragraph\"><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 class=\"wp-block-paragraph\"><\/p>\n\n\n\n<p class=\"wp-block-paragraph\"><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 class=\"wp-block-paragraph\"><br><\/p>\n\n\n\n<p class=\"wp-block-paragraph\"><\/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.3","language":"en","enabled_languages":["ko","en"],"languages":{"ko":{"title":true,"content":true,"excerpt":false},"en":{"title":false,"content":false,"excerpt":false}}},"aioseo_notices":[],"aioseo_head":"\n\t\t<!-- All in One SEO 4.9.10 - aioseo.com -->\n\t<meta name=\"description\" content=\"\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. datedif \uc640 vlookup\uc744 \uc0ac\uc6a9\ud574\uc11c \ud45c\uc2dc\ud558\ub294 \ubc29\ubc95\uc744 \uc54c\uc544\ubcf4\uaca0\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,\" \/>\n\t<meta name=\"robots\" content=\"max-image-preview:large\" \/>\n\t<meta name=\"author\" content=\"autooffice\"\/>\n\t<meta name=\"keywords\" content=\"datedif,query,vlookup,\uc2a4\ud504\ub808\ub4dc\uc2dc\ud2b8\" \/>\n\t<link rel=\"canonical\" href=\"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\/\" \/>\n\t<meta name=\"generator\" content=\"All in One SEO (AIOSEO) 4.9.10\" \/>\n\t\t<meta property=\"og:locale\" content=\"en_US\" \/>\n\t\t<meta property=\"og:site_name\" content=\"Tech Blog of autooffice - Sharing Knowhow about automation, apps script, looker studio, BigQuery, spreadsheet.\" \/>\n\t\t<meta property=\"og:type\" content=\"article\" \/>\n\t\t<meta property=\"og:title\" content=\"\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 - Tech Blog of autooffice\" \/>\n\t\t<meta property=\"og:description\" content=\"\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. datedif \uc640 vlookup\uc744 \uc0ac\uc6a9\ud574\uc11c \ud45c\uc2dc\ud558\ub294 \ubc29\ubc95\uc744 \uc54c\uc544\ubcf4\uaca0\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,\" \/>\n\t\t<meta property=\"og:url\" content=\"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\/\" \/>\n\t\t<meta property=\"og:image\" content=\"https:\/\/www.autooffice.co.kr\/wp\/wp-content\/uploads\/2023\/07\/autooffice_share.png\" \/>\n\t\t<meta property=\"og:image:secure_url\" content=\"https:\/\/www.autooffice.co.kr\/wp\/wp-content\/uploads\/2023\/07\/autooffice_share.png\" \/>\n\t\t<meta property=\"og:image:width\" content=\"400\" \/>\n\t\t<meta property=\"og:image:height\" content=\"210\" \/>\n\t\t<meta property=\"article:published_time\" content=\"2020-07-08T15:02:45+00:00\" \/>\n\t\t<meta property=\"article:modified_time\" content=\"2025-09-15T09:57:30+00:00\" \/>\n\t\t<meta name=\"twitter:card\" content=\"summary_large_image\" \/>\n\t\t<meta name=\"twitter:title\" content=\"\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 - Tech Blog of autooffice\" \/>\n\t\t<meta name=\"twitter:description\" content=\"\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. datedif \uc640 vlookup\uc744 \uc0ac\uc6a9\ud574\uc11c \ud45c\uc2dc\ud558\ub294 \ubc29\ubc95\uc744 \uc54c\uc544\ubcf4\uaca0\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,\" \/>\n\t\t<meta name=\"twitter:image\" content=\"https:\/\/www.autooffice.co.kr\/wp\/wp-content\/uploads\/2023\/07\/autooffice_share.png\" \/>\n\t\t<script type=\"application\/ld+json\" class=\"aioseo-schema\">\n\t\t\t{\"@context\":\"https:\\\/\\\/schema.org\",\"@graph\":[{\"@type\":\"BlogPosting\",\"@id\":\"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\\\/#blogposting\",\"name\":\"\\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 - Tech Blog of autooffice\",\"headline\":\"\\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\",\"author\":{\"@id\":\"https:\\\/\\\/www.autooffice.co.kr\\\/en\\\/blog\\\/author\\\/autooffice\\\/#author\"},\"publisher\":{\"@id\":\"https:\\\/\\\/www.autooffice.co.kr\\\/en\\\/#organization\"},\"image\":{\"@type\":\"ImageObject\",\"url\":\"https:\\\/\\\/www.autooffice.co.kr\\\/wp\\\/wp-content\\\/uploads\\\/2020\\\/07\\\/image-35.png\",\"width\":1719,\"height\":746},\"datePublished\":\"2020-07-09T00:02:45+09:00\",\"dateModified\":\"2025-09-15T18:57:30+09:00\",\"inLanguage\":\"en-US\",\"mainEntityOfPage\":{\"@id\":\"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\\\/#webpage\"},\"isPartOf\":{\"@id\":\"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\\\/#webpage\"},\"articleSection\":\"\\uc2a4\\ud504\\ub808\\ub4dc\\uc2dc\\ud2b8, datedif, QUERY, VLOOKUP\"},{\"@type\":\"BreadcrumbList\",\"@id\":\"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\\\/#breadcrumblist\",\"itemListElement\":[{\"@type\":\"ListItem\",\"@id\":\"https:\\\/\\\/www.autooffice.co.kr\\\/en#listItem\",\"position\":1,\"name\":\"Home\",\"item\":\"https:\\\/\\\/www.autooffice.co.kr\\\/en\",\"nextItem\":{\"@type\":\"ListItem\",\"@id\":\"https:\\\/\\\/www.autooffice.co.kr\\\/en\\\/blog\\\/category\\\/spreadsheet\\\/#listItem\",\"name\":\"\\uc2a4\\ud504\\ub808\\ub4dc\\uc2dc\\ud2b8\"}},{\"@type\":\"ListItem\",\"@id\":\"https:\\\/\\\/www.autooffice.co.kr\\\/en\\\/blog\\\/category\\\/spreadsheet\\\/#listItem\",\"position\":2,\"name\":\"\\uc2a4\\ud504\\ub808\\ub4dc\\uc2dc\\ud2b8\",\"item\":\"https:\\\/\\\/www.autooffice.co.kr\\\/en\\\/blog\\\/category\\\/spreadsheet\\\/\",\"nextItem\":{\"@type\":\"ListItem\",\"@id\":\"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\\\/#listItem\",\"name\":\"\\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\"},\"previousItem\":{\"@type\":\"ListItem\",\"@id\":\"https:\\\/\\\/www.autooffice.co.kr\\\/en#listItem\",\"name\":\"Home\"}},{\"@type\":\"ListItem\",\"@id\":\"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\\\/#listItem\",\"position\":3,\"name\":\"\\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\",\"previousItem\":{\"@type\":\"ListItem\",\"@id\":\"https:\\\/\\\/www.autooffice.co.kr\\\/en\\\/blog\\\/category\\\/spreadsheet\\\/#listItem\",\"name\":\"\\uc2a4\\ud504\\ub808\\ub4dc\\uc2dc\\ud2b8\"}}]},{\"@type\":\"Organization\",\"@id\":\"https:\\\/\\\/www.autooffice.co.kr\\\/en\\\/#organization\",\"name\":\"\\uc624\\ud1a0\\uc624\\ud53c\\uc2a4\",\"description\":\"Sharing Knowhow about automation, apps script, looker studio, BigQuery, spreadsheet.\",\"url\":\"https:\\\/\\\/www.autooffice.co.kr\\\/en\\\/\",\"telephone\":\"+821024904264\",\"logo\":{\"@type\":\"ImageObject\",\"url\":\"https:\\\/\\\/www.autooffice.co.kr\\\/wp\\\/wp-content\\\/uploads\\\/2023\\\/07\\\/logo-new2023.png\",\"@id\":\"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\\\/#organizationLogo\",\"width\":1461,\"height\":250},\"image\":{\"@id\":\"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\\\/#organizationLogo\"}},{\"@type\":\"Person\",\"@id\":\"https:\\\/\\\/www.autooffice.co.kr\\\/en\\\/blog\\\/author\\\/autooffice\\\/#author\",\"url\":\"https:\\\/\\\/www.autooffice.co.kr\\\/en\\\/blog\\\/author\\\/autooffice\\\/\",\"name\":\"autooffice\"},{\"@type\":\"WebPage\",\"@id\":\"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\\\/#webpage\",\"url\":\"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\\\/\",\"name\":\"\\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 - Tech Blog of autooffice\",\"description\":\"\\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. datedif \\uc640 vlookup\\uc744 \\uc0ac\\uc6a9\\ud574\\uc11c \\ud45c\\uc2dc\\ud558\\ub294 \\ubc29\\ubc95\\uc744 \\uc54c\\uc544\\ubcf4\\uaca0\\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,\",\"inLanguage\":\"en-US\",\"isPartOf\":{\"@id\":\"https:\\\/\\\/www.autooffice.co.kr\\\/en\\\/#website\"},\"breadcrumb\":{\"@id\":\"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\\\/#breadcrumblist\"},\"author\":{\"@id\":\"https:\\\/\\\/www.autooffice.co.kr\\\/en\\\/blog\\\/author\\\/autooffice\\\/#author\"},\"creator\":{\"@id\":\"https:\\\/\\\/www.autooffice.co.kr\\\/en\\\/blog\\\/author\\\/autooffice\\\/#author\"},\"image\":{\"@type\":\"ImageObject\",\"url\":\"https:\\\/\\\/www.autooffice.co.kr\\\/wp\\\/wp-content\\\/uploads\\\/2020\\\/07\\\/image-35.png\",\"@id\":\"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\\\/#mainImage\",\"width\":1719,\"height\":746},\"primaryImageOfPage\":{\"@id\":\"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\\\/#mainImage\"},\"datePublished\":\"2020-07-09T00:02:45+09:00\",\"dateModified\":\"2025-09-15T18:57:30+09:00\"},{\"@type\":\"WebSite\",\"@id\":\"https:\\\/\\\/www.autooffice.co.kr\\\/en\\\/#website\",\"url\":\"https:\\\/\\\/www.autooffice.co.kr\\\/en\\\/\",\"name\":\"\\uc624\\ud1a0\\uc624\\ud53c\\uc2a4\",\"alternateName\":\"autooffice\",\"description\":\"Sharing Knowhow about automation, apps script, looker studio, BigQuery, spreadsheet.\",\"inLanguage\":\"en-US\",\"publisher\":{\"@id\":\"https:\\\/\\\/www.autooffice.co.kr\\\/en\\\/#organization\"}}]}\n\t\t<\/script>\n\t\t<!-- All in One SEO -->\n\n","aioseo_head_json":{"title":"\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 - Tech Blog of autooffice","description":"\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. datedif \uc640 vlookup\uc744 \uc0ac\uc6a9\ud574\uc11c \ud45c\uc2dc\ud558\ub294 \ubc29\ubc95\uc744 \uc54c\uc544\ubcf4\uaca0\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,","canonical_url":"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\/","robots":"max-image-preview:large","keywords":"datedif,query,vlookup,\uc2a4\ud504\ub808\ub4dc\uc2dc\ud2b8","webmasterTools":{"miscellaneous":""},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"BlogPosting","@id":"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\/#blogposting","name":"\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 - Tech Blog of autooffice","headline":"\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","author":{"@id":"https:\/\/www.autooffice.co.kr\/en\/blog\/author\/autooffice\/#author"},"publisher":{"@id":"https:\/\/www.autooffice.co.kr\/en\/#organization"},"image":{"@type":"ImageObject","url":"https:\/\/www.autooffice.co.kr\/wp\/wp-content\/uploads\/2020\/07\/image-35.png","width":1719,"height":746},"datePublished":"2020-07-09T00:02:45+09:00","dateModified":"2025-09-15T18:57:30+09:00","inLanguage":"en-US","mainEntityOfPage":{"@id":"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\/#webpage"},"isPartOf":{"@id":"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\/#webpage"},"articleSection":"\uc2a4\ud504\ub808\ub4dc\uc2dc\ud2b8, datedif, QUERY, VLOOKUP"},{"@type":"BreadcrumbList","@id":"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\/#breadcrumblist","itemListElement":[{"@type":"ListItem","@id":"https:\/\/www.autooffice.co.kr\/en#listItem","position":1,"name":"Home","item":"https:\/\/www.autooffice.co.kr\/en","nextItem":{"@type":"ListItem","@id":"https:\/\/www.autooffice.co.kr\/en\/blog\/category\/spreadsheet\/#listItem","name":"\uc2a4\ud504\ub808\ub4dc\uc2dc\ud2b8"}},{"@type":"ListItem","@id":"https:\/\/www.autooffice.co.kr\/en\/blog\/category\/spreadsheet\/#listItem","position":2,"name":"\uc2a4\ud504\ub808\ub4dc\uc2dc\ud2b8","item":"https:\/\/www.autooffice.co.kr\/en\/blog\/category\/spreadsheet\/","nextItem":{"@type":"ListItem","@id":"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\/#listItem","name":"\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"},"previousItem":{"@type":"ListItem","@id":"https:\/\/www.autooffice.co.kr\/en#listItem","name":"Home"}},{"@type":"ListItem","@id":"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\/#listItem","position":3,"name":"\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","previousItem":{"@type":"ListItem","@id":"https:\/\/www.autooffice.co.kr\/en\/blog\/category\/spreadsheet\/#listItem","name":"\uc2a4\ud504\ub808\ub4dc\uc2dc\ud2b8"}}]},{"@type":"Organization","@id":"https:\/\/www.autooffice.co.kr\/en\/#organization","name":"\uc624\ud1a0\uc624\ud53c\uc2a4","description":"Sharing Knowhow about automation, apps script, looker studio, BigQuery, spreadsheet.","url":"https:\/\/www.autooffice.co.kr\/en\/","telephone":"+821024904264","logo":{"@type":"ImageObject","url":"https:\/\/www.autooffice.co.kr\/wp\/wp-content\/uploads\/2023\/07\/logo-new2023.png","@id":"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\/#organizationLogo","width":1461,"height":250},"image":{"@id":"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\/#organizationLogo"}},{"@type":"Person","@id":"https:\/\/www.autooffice.co.kr\/en\/blog\/author\/autooffice\/#author","url":"https:\/\/www.autooffice.co.kr\/en\/blog\/author\/autooffice\/","name":"autooffice"},{"@type":"WebPage","@id":"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\/#webpage","url":"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\/","name":"\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 - Tech Blog of autooffice","description":"\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. datedif \uc640 vlookup\uc744 \uc0ac\uc6a9\ud574\uc11c \ud45c\uc2dc\ud558\ub294 \ubc29\ubc95\uc744 \uc54c\uc544\ubcf4\uaca0\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,","inLanguage":"en-US","isPartOf":{"@id":"https:\/\/www.autooffice.co.kr\/en\/#website"},"breadcrumb":{"@id":"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\/#breadcrumblist"},"author":{"@id":"https:\/\/www.autooffice.co.kr\/en\/blog\/author\/autooffice\/#author"},"creator":{"@id":"https:\/\/www.autooffice.co.kr\/en\/blog\/author\/autooffice\/#author"},"image":{"@type":"ImageObject","url":"https:\/\/www.autooffice.co.kr\/wp\/wp-content\/uploads\/2020\/07\/image-35.png","@id":"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\/#mainImage","width":1719,"height":746},"primaryImageOfPage":{"@id":"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\/#mainImage"},"datePublished":"2020-07-09T00:02:45+09:00","dateModified":"2025-09-15T18:57:30+09:00"},{"@type":"WebSite","@id":"https:\/\/www.autooffice.co.kr\/en\/#website","url":"https:\/\/www.autooffice.co.kr\/en\/","name":"\uc624\ud1a0\uc624\ud53c\uc2a4","alternateName":"autooffice","description":"Sharing Knowhow about automation, apps script, looker studio, BigQuery, spreadsheet.","inLanguage":"en-US","publisher":{"@id":"https:\/\/www.autooffice.co.kr\/en\/#organization"}}]},"og:locale":"en_US","og:site_name":"Tech Blog of autooffice - Sharing Knowhow about automation, apps script, looker studio, BigQuery, spreadsheet.","og:type":"article","og:title":"\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 - Tech Blog of autooffice","og:description":"\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. datedif \uc640 vlookup\uc744 \uc0ac\uc6a9\ud574\uc11c \ud45c\uc2dc\ud558\ub294 \ubc29\ubc95\uc744 \uc54c\uc544\ubcf4\uaca0\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,","og:url":"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\/","og:image":"https:\/\/www.autooffice.co.kr\/wp\/wp-content\/uploads\/2023\/07\/autooffice_share.png","og:image:secure_url":"https:\/\/www.autooffice.co.kr\/wp\/wp-content\/uploads\/2023\/07\/autooffice_share.png","og:image:width":400,"og:image:height":210,"article:published_time":"2020-07-08T15:02:45+00:00","article:modified_time":"2025-09-15T09:57:30+00:00","twitter:card":"summary_large_image","twitter:title":"\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 - Tech Blog of autooffice","twitter:description":"\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. datedif \uc640 vlookup\uc744 \uc0ac\uc6a9\ud574\uc11c \ud45c\uc2dc\ud558\ub294 \ubc29\ubc95\uc744 \uc54c\uc544\ubcf4\uaca0\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,","twitter:image":"https:\/\/www.autooffice.co.kr\/wp\/wp-content\/uploads\/2023\/07\/autooffice_share.png"},"aioseo_meta_data":{"post_id":"3071","title":null,"description":null,"keywords":null,"keyphrases":{"focus":{"keyphrase":"","score":0,"analysis":{"keyphraseInTitle":{"score":0,"maxScore":9,"error":1}}},"additional":[]},"primary_term":null,"canonical_url":null,"og_title":null,"og_description":null,"og_object_type":"default","og_image_type":"default","og_image_url":null,"og_image_width":null,"og_image_height":null,"og_image_custom_url":null,"og_image_custom_fields":null,"og_video":"","og_custom_url":null,"og_article_section":null,"og_article_tags":null,"twitter_use_og":false,"twitter_card":"default","twitter_image_type":"default","twitter_image_url":null,"twitter_image_custom_url":null,"twitter_image_custom_fields":null,"twitter_title":null,"twitter_description":null,"schema":{"blockGraphs":[],"customGraphs":[],"default":{"data":{"Article":[],"Course":[],"Dataset":[],"FAQPage":[],"Movie":[],"Person":[],"Product":[],"ProductReview":[],"Car":[],"Recipe":[],"Service":[],"SoftwareApplication":[],"WebPage":[]},"graphName":"BlogPosting","isEnabled":true},"graphs":[]},"schema_type":"default","schema_type_options":null,"pillar_content":false,"robots_default":true,"robots_noindex":false,"robots_noarchive":false,"robots_nosnippet":false,"robots_nofollow":false,"robots_noimageindex":false,"robots_noodp":false,"robots_notranslate":false,"robots_max_snippet":"-1","robots_max_videopreview":"-1","robots_max_imagepreview":"large","priority":null,"frequency":"default","local_seo":null,"breadcrumb_settings":null,"limit_modified_date":false,"ai":{"faqs":[],"keyPoints":[],"titles":[],"descriptions":[],"socialPosts":{"email":[],"linkedin":[],"twitter":[],"facebook":[],"instagram":[]}},"created":"2023-07-15 14:25:20","updated":"2025-09-15 09:58:10","seo_analyzer_scan_date":null},"aioseo_breadcrumb":"<div class=\"aioseo-breadcrumbs\"><span class=\"aioseo-breadcrumb\">\n\t\t\t<a href=\"https:\/\/www.autooffice.co.kr\/en\" title=\"Home\">Home<\/a>\n\t\t<\/span><span class=\"aioseo-breadcrumb-separator\">&raquo;<\/span><span class=\"aioseo-breadcrumb\">\n\t\t\t<a href=\"https:\/\/www.autooffice.co.kr\/en\/blog\/category\/spreadsheet\/\" title=\"\uc2a4\ud504\ub808\ub4dc\uc2dc\ud2b8\">\uc2a4\ud504\ub808\ub4dc\uc2dc\ud2b8<\/a>\n\t\t<\/span><span class=\"aioseo-breadcrumb-separator\">&raquo;<\/span><span class=\"aioseo-breadcrumb\">\n\t\t\t\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\n\t\t<\/span><\/div>","aioseo_breadcrumb_json":[{"label":"Home","link":"https:\/\/www.autooffice.co.kr\/en"},{"label":"\uc2a4\ud504\ub808\ub4dc\uc2dc\ud2b8","link":"https:\/\/www.autooffice.co.kr\/en\/blog\/category\/spreadsheet\/"},{"label":"\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","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\/"}],"_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}]}}