{"id":280498,"date":"2023-11-07T23:48:11","date_gmt":"2023-11-07T16:48:11","guid":{"rendered":"https:\/\/hoanghamobile.com\/tin-tuc\/?p=280498"},"modified":"2023-11-07T23:48:11","modified_gmt":"2023-11-07T16:48:11","slug":"ham-datedif","status":"publish","type":"post","link":"https:\/\/hoanghamobile.com\/tin-tuc\/ham-datedif\/","title":{"rendered":"C\u00e1ch d\u00f9ng h\u00e0m DATEDIF t\u00ednh ch\u00eanh l\u1ec7ch gi\u1eefa 2 ng\u00e0y trong Google Sheet"},"content":{"rendered":"<p>Khi s\u1eed d\u1ee5ng Google Sheet c\u00f3 c\u00e1c d\u1eef li\u1ec7u li\u00ean quan \u0111\u1ebfn ng\u00e0y\/ th\u00e1ng, kh\u00e1 nhi\u1ec1u ng\u01b0\u1eddi g\u1eb7p h\u00e0m DATEDIF nh\u01b0ng v\u1eabn ch\u01b0a c\u00e1ch \u00e1p d\u1ee5ng nh\u01b0 th\u1ebf n\u00e0o. \u0110\u1ec3 s\u1eed d\u1ee5ng h\u00e0m n\u00e0y hi\u1ec7u qu\u1ea3 h\u01a1n trong c\u00f4ng vi\u1ec7c, b\u1ea1n h\u00e3y theo d\u00f5i b\u00e0i vi\u1ebft sau \u0111\u1ec3 bi\u1ebft \u0111\u00e2y l\u00e0 h\u00e0m g\u00ec v\u00e0 c\u00f4ng th\u1ee9c d\u00f9ng h\u00e0m ra sao.<\/p>\n<h2>H\u00e0m DATEDIF l\u00e0 h\u00e0m g\u00ec? C\u00f4ng th\u1ee9c d\u00f9ng h\u00e0m?<\/h2>\n<p>\u0110\u00e2y l\u00e0 m\u1ed9t h\u00e0m trong Google Sheet d\u00f9ng \u0111\u1ec3 t\u00ednh to\u00e1n m\u1ee9c ch\u00eanh l\u1ec7ch gi\u1eefa hai gi\u00e1 tr\u1ecb th\u1eddi gian. Ng\u01b0\u1eddi d\u00f9ng c\u00f3 th\u1ec3 s\u1eed d\u1ee5ng h\u00e0m n\u00e0y \u0111\u1ec3 t\u00ednh to\u00e1n kho\u1ea3ng ch\u00eanh l\u1ec7ch gi\u1eefa 2 s\u1ed1 li\u1ec7u \u0111\u01b0\u1ee3c \u0111\u1ecbnh d\u1ea1ng ng\u00e0y\/ th\u00e1ng\/ n\u0103m \u0111\u1ec3 cho ra k\u1ebft qu\u1ea3 l\u00e0 gi\u00e1 tr\u1ecb th\u1ef1c trong kho\u1ea3ng bao nhi\u00eau ng\u00e0y.<\/p>\n<p>C\u00f4ng th\u1ee9c d\u00f9ng h\u00e0m DATEDIF trong Google Sheet c\u1ee5 th\u1ec3 nh\u01b0 sau:<\/p>\n<p>=DATEDIF(start_date, end_date, unit)<\/p>\n<figure id=\"attachment_280524\" aria-describedby=\"caption-attachment-280524\" style=\"width: 800px\" class=\"wp-caption aligncenter\"><picture><source srcset=\"https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/webp-express\/webp-images\/uploads\/2023\/10\/ham-datedif-1.jpg.webp 800w, https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/webp-express\/webp-images\/uploads\/2023\/10\/ham-datedif-1-300x169.jpg.webp 300w, https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/webp-express\/webp-images\/uploads\/2023\/10\/ham-datedif-1-768x432.jpg.webp 768w\" sizes=\"(max-width: 800px) 100vw, 800px\" type=\"image\/webp\"><img fetchpriority=\"high\" decoding=\"async\" class=\"wp-image-280524 size-full webpexpress-processed\" src=\"https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/uploads\/2023\/10\/ham-datedif-1.jpg\" alt=\"ham-datedif-1\" width=\"800\" height=\"450\" srcset=\"https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/uploads\/2023\/10\/ham-datedif-1.jpg 800w, https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/uploads\/2023\/10\/ham-datedif-1-300x169.jpg 300w, https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/uploads\/2023\/10\/ham-datedif-1-768x432.jpg 768w\" sizes=\"(max-width: 800px) 100vw, 800px\"><\/picture><figcaption id=\"caption-attachment-280524\" class=\"wp-caption-text\">H\u00e0m DATEDIF l\u00e0 h\u00e0m g\u00ec? C\u00f4ng th\u1ee9c d\u00f9ng h\u00e0m?<\/figcaption><\/figure>\n<p>Trong c\u00f4ng th\u1ee9c n\u00e0y:<\/p>\n<ul>\n<li style=\"font-weight: 400;\">Start_date: Ng\u00e0y b\u1eaft \u0111\u1ea7u trong ph\u00e9p t\u00ednh. D\u1eef li\u1ec7u \u0111\u1ea7u v\u00e0o n\u00e0y ph\u1ea3i \u0111\u01b0\u1ee3c \u0111\u1ecbnh d\u1ea1ng ki\u1ec3u Date.<\/li>\n<li style=\"font-weight: 400;\">End_date: Ng\u00e0y k\u1ebft th\u00fac trong ph\u00e9p t\u00ednh. D\u1eef li\u1ec7u n\u00e0y c\u0169ng c\u1ea7n \u0111\u1ecbnh d\u1ea1ng theo ki\u1ec3u Date.<\/li>\n<li style=\"font-weight: 400;\">Unit: Ch\u1eef vi\u1ebft t\u1eaft c\u1ee7a \u0111\u01a1n v\u1ecb th\u1eddi gian d\u00e0nh cho k\u1ebft qu\u1ea3 m\u00e0 h\u00e0m tr\u1ea3 v\u1ec1. Tr\u01b0\u1eddng h\u1ee3p n\u00e0y th\u00ec m\u1ecdi ng\u01b0\u1eddi c\u00f3 th\u1ec3 ch\u1ecdn nh\u1eefng c\u00e1ch hi\u1ec3n th\u1ecb nh\u01b0 sau:\n<ul>\n<li style=\"font-weight: 400;\">\u201cD\u201d: H\u00e0m tr\u1ea3 v\u1ec1 k\u1ebft qu\u1ea3 \u0111\u01b0\u1ee3c l\u00e0m tr\u00f2n l\u00ean theo ng\u00e0y<\/li>\n<li style=\"font-weight: 400;\">\u201cM\u201d: H\u00e0m tr\u1ea3 v\u1ec1 k\u1ebft qu\u1ea3 \u0111\u01b0\u1ee3c l\u00e0m tr\u00f2n l\u00ean theo th\u00e1ng<\/li>\n<li style=\"font-weight: 400;\">\u201cY\u201d: H\u00e0m tr\u1ea3 v\u1ec1 k\u1ebft qu\u1ea3 \u0111\u01b0\u1ee3c l\u00e0m tr\u00f2n l\u00ean theo n\u0103m<\/li>\n<li style=\"font-weight: 400;\">\u201cMD\u201d: H\u00e0m tr\u1ea3 v\u1ec1 k\u1ebft qu\u1ea3 l\u00e0 m\u1ee9c ch\u00eanh l\u1ec7ch theo ng\u00e0y. H\u00e0m b\u1ecf qua y\u1ebfu t\u1ed1 th\u00e1ng, n\u0103m c\u1ee7a ng\u00e0y<\/li>\n<li style=\"font-weight: 400;\">&#8220;YM&#8221;: H\u00e0m tr\u1ea3 v\u1ec1 k\u1ebft qu\u1ea3 l\u00e0 m\u1ee9c ch\u00eanh l\u1ec7ch theo th\u00e1ng. H\u00e0m b\u1ecf qua y\u1ebfu t\u1ed1 ng\u00e0y, n\u0103m c\u1ee7a th\u00e1ng<\/li>\n<li style=\"font-weight: 400;\">\u201cYD\u201d: H\u00e0m tr\u1ea3 v\u1ec1 k\u1ebft qu\u1ea3 l\u00e0 m\u1ee9c ch\u00eanh l\u1ec7ch theo ng\u00e0y. H\u00e0m b\u1ecf qua y\u1ebfu t\u1ed1 l\u00e0 n\u0103m c\u1ee7a ng\u00e0y<\/li>\n<\/ul>\n<\/li>\n<\/ul>\n<p>Nh\u1eefng \u0111\u1ed1i s\u1ed1 \u1edf tr\u00ean \u0111\u1ec1u l\u00e0 nh\u1eefng \u0111\u1ed1i s\u1ed1 b\u1eaft bu\u1ed9c ph\u1ea3i c\u00f3 trong h\u00e0m DATEDIF. B\u00ean c\u1ea1nh \u0111\u00f3, ng\u01b0\u1eddi d\u00f9ng n\u00ean ch\u00fa \u00fd khi d\u00f9ng Unit v\u1edbi \u0111\u1ecbnh d\u1ea1ng l\u00e0 \u201cMD\u201d. Ti\u00eau chu\u1ea9n n\u00e0y s\u1ebd m\u1eb7c \u0111\u1ecbnh 2 ng\u00e0y n\u00e0y c\u00f9ng th\u00e1ng v\u00e0 c\u00f9ng n\u0103m. V\u00ec v\u1eady m\u00e0 c\u00f3 v\u00e0i t\u00ecnh hu\u1ed1ng s\u1ebd l\u00e0m cho ph\u00e9p t\u00ednh b\u1ecb nh\u1ea7m l\u1eabn.<\/p>\n<h2>C\u00e1ch d\u00f9ng h\u00e0m DATEDIF t\u00ednh ch\u00eanh l\u1ec7ch gi\u1eefa hai th\u1eddi \u0111i\u1ec3m trong Google Sheet<\/h2>\n<p>Sau \u0111\u00e2y l\u00e0 nh\u1eefng v\u00ed d\u1ee5 v\u1ec1 c\u00e1ch d\u00f9ng h\u00e0m DATEDIF \u0111\u1ec3 t\u00ednh m\u1ee9c ch\u00eanh l\u1ec7ch gi\u1eefa hai ng\u00e0y trong Google Sheet:<\/p>\n<h3>V\u00ed d\u1ee5 \u0111\u1ebfm h\u1ebft c\u00e1c ng\u00e0y<\/h3>\n<p>V\u00ed d\u1ee5 ta c\u00f3 b\u1ea3ng d\u1eef li\u1ec7u tr\u00ean Google Sheet \u0111\u1ec3 qu\u1ea3n l\u00fd \u0111\u1eb7t h\u00e0ng nh\u01b0 h\u00ecnh sau. T\u1ea5t c\u1ea3 \u0111\u01a1n \u0111\u1eb7t h\u00e0ng n\u00e0y \u0111\u00e3 \u0111\u01b0\u1ee3c cho xu\u1ea5t x\u01b0\u1edfng trong \u0111\u1ea7u th\u00e1ng 8. Ng\u00e0y b\u1eaft \u0111\u1ea7u v\u1eadn chuy\u1ec3n \u0111\u01b0\u1ee3c k\u00fd hi\u1ec7u l\u00e0 Shipping Date trong b\u1ea3ng. C\u00f2n ng\u00e0y giao h\u00e0ng hay c\u00f2n g\u1ecdi l\u00e0 ng\u00e0y \u0111\u1ebfn h\u1ea1n \u0111\u01b0\u1ee3c k\u00fd hi\u1ec7u l\u00e0 Due Date trong b\u1ea3ng.<\/p>\n<p><picture><source srcset=\"https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/webp-express\/webp-images\/uploads\/2023\/10\/ham-datedif-2.jpg.webp 800w, https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/webp-express\/webp-images\/uploads\/2023\/10\/ham-datedif-2-300x169.jpg.webp 300w, https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/webp-express\/webp-images\/uploads\/2023\/10\/ham-datedif-2-768x432.jpg.webp 768w\" sizes=\"(max-width: 800px) 100vw, 800px\" type=\"image\/webp\"><img decoding=\"async\" class=\"size-full wp-image-280525 aligncenter webpexpress-processed\" src=\"https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/uploads\/2023\/10\/ham-datedif-2.jpg\" alt=\"ham-datedif-2\" width=\"800\" height=\"450\" srcset=\"https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/uploads\/2023\/10\/ham-datedif-2.jpg 800w, https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/uploads\/2023\/10\/ham-datedif-2-300x169.jpg 300w, https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/uploads\/2023\/10\/ham-datedif-2-768x432.jpg 768w\" sizes=\"(max-width: 800px) 100vw, 800px\"><\/picture><\/p>\n<p>L\u00fac n\u00e0y b\u1ea1n ph\u1ea3i t\u00ednh s\u1ed1 ng\u00e0y ch\u00eanh l\u1ec7ch gi\u1eefa ng\u00e0y b\u1eaft \u0111\u1ea7u v\u1eadn chuy\u1ec3n v\u00e0 ng\u00e0y t\u1edbi h\u1ea1n \u0111\u1ec3 xem m\u1ea5t bao l\u00e2u \u0111\u1ec3 \u0111\u01a1n h\u00e0ng t\u1edbi n\u01a1i (s\u1ed1 ng\u00e0y ch\u00eanh l\u1ec7ch n\u00e0y \u0111\u01b0\u1ee3c k\u00fd hi\u1ec7u l\u00e0 &#8220;D&#8221;). Sau \u0111\u00e2y l\u00e0 c\u00e1ch s\u1eed d\u1ee5ng h\u00e0m DATEDIF m\u00e0 b\u1ea1n n\u00ean nh\u1eadp v\u00e0o \u0111\u1ec3 t\u00ednh to\u00e1n:<\/p>\n<p>=DATEDIF(B2,C2,&#8221;D&#8221;)<\/p>\n<p><picture><source srcset=\"https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/webp-express\/webp-images\/uploads\/2023\/10\/ham-datedif-3.jpg.webp 800w, https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/webp-express\/webp-images\/uploads\/2023\/10\/ham-datedif-3-300x169.jpg.webp 300w, https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/webp-express\/webp-images\/uploads\/2023\/10\/ham-datedif-3-768x432.jpg.webp 768w\" sizes=\"(max-width: 800px) 100vw, 800px\" type=\"image\/webp\"><img decoding=\"async\" class=\"size-full wp-image-280526 aligncenter webpexpress-processed\" src=\"https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/uploads\/2023\/10\/ham-datedif-3.jpg\" alt=\"ham-datedif-3\" width=\"800\" height=\"450\" srcset=\"https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/uploads\/2023\/10\/ham-datedif-3.jpg 800w, https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/uploads\/2023\/10\/ham-datedif-3-300x169.jpg 300w, https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/uploads\/2023\/10\/ham-datedif-3-768x432.jpg 768w\" sizes=\"(max-width: 800px) 100vw, 800px\"><\/picture><\/p>\n<p>B\u1ea1n ch\u1ec9 c\u1ea7n \u0111i\u1ec1n c\u00f4ng th\u1ee9c tr\u00ean v\u00e0o \u00f4 D2 r\u1ed3i sao ch\u00e9p v\u00e0o c\u00e1c \u00f4 kh\u00e1c \u1edf trong c\u1ed9t \u0111\u00f3 l\u00e0 c\u00f3 th\u1ec3 t\u00ednh to\u00e1n nhanh ch\u00f3ng cho nh\u1eefng h\u00e0ng \u1edf d\u01b0\u1edbi.<\/p>\n<p>Ch\u00fa \u00fd: B\u1ea1n c\u00f3 th\u1ec3 t\u00ecm ra s\u1ed1 ng\u00e0y ch\u00eanh l\u1ec7ch cho to\u00e0n c\u1ed9t c\u00f9ng l\u00fac v\u1edbi 1 c\u00f4ng th\u1ee9c b\u1eb1ng h\u00e0m ARRAYFORMULA nh\u01b0 sau:<\/p>\n<p>=ArrayFormula(DATEDIF(B2:B13,C2:C13,&#8221;D&#8221;))<\/p>\n<p><picture><source srcset=\"https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/webp-express\/webp-images\/uploads\/2023\/10\/ham-datedif-4.jpg.webp 800w, https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/webp-express\/webp-images\/uploads\/2023\/10\/ham-datedif-4-300x169.jpg.webp 300w, https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/webp-express\/webp-images\/uploads\/2023\/10\/ham-datedif-4-768x432.jpg.webp 768w\" sizes=\"(max-width: 800px) 100vw, 800px\" type=\"image\/webp\"><img loading=\"lazy\" decoding=\"async\" class=\"size-full wp-image-280527 aligncenter webpexpress-processed\" src=\"https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/uploads\/2023\/10\/ham-datedif-4.jpg\" alt=\"ham-datedif-4\" width=\"800\" height=\"450\" srcset=\"https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/uploads\/2023\/10\/ham-datedif-4.jpg 800w, https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/uploads\/2023\/10\/ham-datedif-4-300x169.jpg 300w, https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/uploads\/2023\/10\/ham-datedif-4-768x432.jpg 768w\" sizes=\"(max-width: 800px) 100vw, 800px\"><\/picture><\/p>\n<h3>V\u00ed d\u1ee5 \u0111\u1ebfm ng\u00e0y v\u00e0 lo\u1ea1i tr\u1eeb th\u00e1ng<\/h3>\n<p>N\u1ebfu nh\u01b0 m\u1ecdi ng\u01b0\u1eddi mu\u1ed1n t\u00ednh to\u00e1n s\u1ed1 ng\u00e0y ch\u00eanh l\u1ec7ch gi\u1eefa v\u00e0i th\u00e1ng trong b\u1ea3ng d\u01b0\u1edbi \u0111\u00e2y th\u00ec b\u1ea1n h\u00e3y b\u1ecf qua c\u00e1c th\u00e1ng \u0111\u00e3 qua r\u1ed3i d\u00f9ng h\u00e0m DATEDIF \u0111\u1ec3 t\u00ednh to\u00e1n b\u1eb1ng \u0111\u01a1n v\u1ecb \u201cMD\u201d nh\u01b0 sau:<\/p>\n<p>=DATEDIF(A2, B2,&#8221;MD&#8221;)<\/p>\n<figure id=\"attachment_280528\" aria-describedby=\"caption-attachment-280528\" style=\"width: 800px\" class=\"wp-caption aligncenter\"><picture><source srcset=\"https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/webp-express\/webp-images\/uploads\/2023\/10\/ham-datedif-5.jpg.webp 800w, https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/webp-express\/webp-images\/uploads\/2023\/10\/ham-datedif-5-300x169.jpg.webp 300w, https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/webp-express\/webp-images\/uploads\/2023\/10\/ham-datedif-5-768x432.jpg.webp 768w\" sizes=\"(max-width: 800px) 100vw, 800px\" type=\"image\/webp\"><img loading=\"lazy\" decoding=\"async\" class=\"wp-image-280528 size-full webpexpress-processed\" src=\"https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/uploads\/2023\/10\/ham-datedif-5.jpg\" alt=\"ham-datedif-5\" width=\"800\" height=\"450\" srcset=\"https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/uploads\/2023\/10\/ham-datedif-5.jpg 800w, https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/uploads\/2023\/10\/ham-datedif-5-300x169.jpg 300w, https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/uploads\/2023\/10\/ham-datedif-5-768x432.jpg 768w\" sizes=\"(max-width: 800px) 100vw, 800px\"><\/picture><figcaption id=\"caption-attachment-280528\" class=\"wp-caption-text\">V\u00ed d\u1ee5 \u0111\u1ebfm ng\u00e0y v\u00e0 b\u1ecf qua th\u00e1ng<\/figcaption><\/figure>\n<p>Khi t\u00ednh to\u00e1n b\u1eb1ng c\u00f4ng th\u1ee9c tr\u00ean th\u00ec b\u1ea1n s\u1ebd t\u00ednh to\u00e1n \u0111\u01b0\u1ee3c s\u1ed1 ng\u00e0y c\u00f2n l\u1ea1i v\u00e0 lo\u1ea1i tr\u1eeb \u0111\u01b0\u1ee3c nh\u1eefng th\u00e1ng \u0111\u00e3 qua.<\/p>\n<h3>V\u00ed d\u1ee5 \u0111\u1ebfm ng\u00e0y v\u00e0 lo\u1ea1i tr\u1eeb n\u0103m<\/h3>\n<p>\u201cYD\u201d l\u00e0 \u0111\u01a1n v\u1ecb h\u1ed7 tr\u1ee3 t\u00ednh to\u00e1n khi gi\u1eefa hai th\u1eddi \u0111i\u1ec3m c\u1ea7n t\u00ednh to\u00e1n c\u00f3 h\u01a1n 1 n\u0103m. Sau \u0111\u00e2y l\u00e0 h\u00e0m DATEDIF s\u1ebd gi\u00fap b\u1ea1n \u0111\u1ebfm ng\u00e0y v\u00e0 b\u1ecf qua n\u0103m:<\/p>\n<p>=DATEDIF(A2,B2,&#8221;YD&#8221;)<\/p>\n<figure id=\"attachment_280529\" aria-describedby=\"caption-attachment-280529\" style=\"width: 800px\" class=\"wp-caption aligncenter\"><picture><source srcset=\"https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/webp-express\/webp-images\/uploads\/2023\/10\/ham-datedif-6.jpg.webp 800w, https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/webp-express\/webp-images\/uploads\/2023\/10\/ham-datedif-6-300x169.jpg.webp 300w, https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/webp-express\/webp-images\/uploads\/2023\/10\/ham-datedif-6-768x432.jpg.webp 768w\" sizes=\"(max-width: 800px) 100vw, 800px\" type=\"image\/webp\"><img loading=\"lazy\" decoding=\"async\" class=\"wp-image-280529 size-full webpexpress-processed\" src=\"https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/uploads\/2023\/10\/ham-datedif-6.jpg\" alt=\"ham-datedif-6\" width=\"800\" height=\"450\" srcset=\"https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/uploads\/2023\/10\/ham-datedif-6.jpg 800w, https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/uploads\/2023\/10\/ham-datedif-6-300x169.jpg 300w, https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/uploads\/2023\/10\/ham-datedif-6-768x432.jpg 768w\" sizes=\"(max-width: 800px) 100vw, 800px\"><\/picture><figcaption id=\"caption-attachment-280529\" class=\"wp-caption-text\">V\u00ed d\u1ee5 \u0111\u1ebfm ng\u00e0y v\u00e0 b\u1ecf qua n\u0103m<\/figcaption><\/figure>\n<p>C\u00f4ng th\u1ee9c tr\u00ean s\u1ebd gi\u00fap b\u1ea1n tr\u1eeb \u0111i n\u0103m \u0111\u1ea7u. Ti\u1ebfp theo th\u00ec c\u00f4ng th\u1ee9c s\u1ebd t\u00ednh nh\u1eefng ng\u00e0y c\u00f2n l\u1ea1i v\u00e0 xem nh\u1eefng ng\u00e0y \u0111\u00f3 \u1edf trong c\u00f9ng 1 n\u0103m.<\/p>\n<h2>H\u01b0\u1edbng d\u1eabn \u0111\u1ebfm ng\u00e0y l\u00e0m vi\u1ec7c trong Google Sheets<\/h2>\n<p>Trong m\u1ed9t s\u1ed1 t\u00ecnh hu\u1ed1ng khi ng\u01b0\u1eddi d\u00f9ng ch\u1ec9 c\u1ea7n \u0111\u1ebfm s\u1ed1 ng\u00e0y \u0111\u00e3 l\u00e0m vi\u1ec7c trong t\u1ea1i Google Sheets th\u00ec h\u00e0m DATEDIF kh\u00f4ng \u0111\u01b0\u1ee3c \u00e1p d\u1ee5ng hi\u1ec7u qu\u1ea3. Sau \u0111\u00e2y l\u00e0 m\u1ed9t s\u1ed1 v\u00ed d\u1ee5 minh h\u1ecda gi\u00fap b\u1ea1n \u0111\u1ebfm s\u1ed1 ng\u00e0y l\u00e0m vi\u1ec7c b\u1eb1ng m\u1ed9t s\u1ed1 h\u00e0m h\u1eefu \u00edch:<\/p>\n<h3>V\u00ed d\u1ee5 d\u00f9ng h\u00e0m NETWORKDAYS \u0111\u1ec3 \u0111\u1ebfm ng\u00e0y l\u00e0m vi\u1ec7c<\/h3>\n<p>H\u00e0m \u0111\u1ea7u ti\u00ean gi\u00fap b\u1ea1n \u0111\u1ebfm s\u1ed1 ng\u00e0y l\u00e0m vi\u1ec7c \u0111\u00f3 l\u00e0 h\u00e0m NETWORKDAYS. C\u00f4ng th\u1ee9c c\u1ee7a h\u00e0m n\u00e0y s\u1ebd gi\u00fap b\u1ea1n \u0111\u1ebfm s\u1ed1 l\u01b0\u1ee3ng ng\u00e0y l\u00e0m vi\u1ec7c khi \u0111\u1eb7t gi\u1eefa 2 ng\u00e0y v\u00e0 kh\u00f4ng t\u00ednh c\u1ea3 th\u1ee9 7, Ch\u1ee7 Nh\u1eadt, ng\u00e0y l\u1ec5 (n\u1ebfu c\u00f3). Ta c\u00f3 c\u00f4ng th\u1ee9c s\u1eed d\u1ee5ng h\u00e0m nh\u01b0 sau:<\/p>\n<p>=NETWORKDAYS(start_date, end_date, [holidays])<\/p>\n<p>Trong c\u00f4ng th\u1ee9c:<\/p>\n<ul>\n<li style=\"font-weight: 400;\">Start_date: Ng\u00e0y kh\u1edfi \u0111i\u1ec3m. N\u1ebfu ng\u00e0y kh\u1edfi \u0111i\u1ec3m kh\u00f4ng ph\u1ea3i ng\u00e0y \u0111\u01b0\u1ee3c ngh\u1ec9, n\u00f3 m\u1eb7c \u0111\u1ecbnh l\u00e0 ng\u00e0y \u0111i l\u00e0m.<\/li>\n<li style=\"font-weight: 400;\">End_date: Ng\u00e0y l\u00e0m \u0111i\u1ec3m k\u1ebft th\u00fac. N\u1ebfu ng\u00e0y l\u00e0m \u0111i\u1ec3m k\u1ebft th\u00fac kh\u00f4ng ph\u1ea3i ng\u00e0y \u0111\u01b0\u1ee3c ngh\u1ec9, n\u00f3 m\u1eb7c \u0111\u1ecbnh l\u00e0 ng\u00e0y \u0111i l\u00e0m.<\/li>\n<li style=\"font-weight: 400;\">Holidays: T\u00f9y ch\u1ecdn gi\u00fap b\u1ea1n \u0111\u01b0a ra nh\u1eefng ng\u00e0y l\u1ec5. B\u1ea1n ph\u1ea3i x\u00e1c \u0111\u1ecbnh n\u00f3 l\u00e0 m\u1ed9t ph\u1ea1m vi v\u1ec1 ng\u00e0y hay m\u1ed9t s\u1ed1 t\u01b0\u1ee3ng tr\u01b0ng cho ng\u00e0y\/ th\u00e1ng.<\/li>\n<\/ul>\n<p>\u0110\u1ec3 gi\u00fap b\u1ea1n h\u00ecnh dung c\u1ee5 th\u1ec3 v\u1ec1 c\u00e1ch \u0111\u1ebfm ng\u00e0y l\u00e0m vi\u1ec7c c\u1ee7a h\u00e0m tr\u00ean, b\u1ea3ng t\u00ednh tr\u00ean s\u1ebd \u0111\u01b0\u1ee3c b\u1ed5 sung danh s\u00e1ch nh\u1eefng ng\u00e0y l\u1ec5 xen gi\u1eefa ng\u00e0y v\u1eadn chuy\u1ec3n v\u00e0 ng\u00e0y t\u1edbi h\u1ea1n nh\u01b0 sau:<\/p>\n<p>Ta c\u00f3 c\u1ed9t B ch\u00ednh l\u00e0 c\u1ed9t c\u1ee7a ng\u00e0y kh\u1edfi \u0111i\u1ec3m v\u00e0 c\u1ed9t C l\u00e0 c\u1ed9t c\u1ee7a ng\u00e0y t\u1edbi h\u1ea1n. Nh\u1eefng ng\u00e0y \u0111\u01b0\u1ee3c li\u1ec7t k\u00ea \u1edf c\u1ed9t E ch\u00ednh l\u00e0 ng\u00e0y l\u1ec5 c\u1ea7n \u0111\u01b0\u1ee3c xem x\u00e9t. Sau \u0111\u00e2y l\u00e0 c\u00e1ch \u00e1p d\u1ee5ng h\u00e0m NETWORKDAYS \u0111\u1ec3 \u0111\u1ebfm s\u1ed1 ng\u00e0y l\u00e0m vi\u1ec7c:<\/p>\n<p>=NETWORKDAYS(B2,C2,$E$2:$E$4)<\/p>\n<figure id=\"attachment_280530\" aria-describedby=\"caption-attachment-280530\" style=\"width: 800px\" class=\"wp-caption aligncenter\"><picture><source srcset=\"https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/webp-express\/webp-images\/uploads\/2023\/10\/ham-datedif-7.jpg.webp 800w, https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/webp-express\/webp-images\/uploads\/2023\/10\/ham-datedif-7-300x169.jpg.webp 300w, https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/webp-express\/webp-images\/uploads\/2023\/10\/ham-datedif-7-768x432.jpg.webp 768w\" sizes=\"(max-width: 800px) 100vw, 800px\" type=\"image\/webp\"><img loading=\"lazy\" decoding=\"async\" class=\"wp-image-280530 size-full webpexpress-processed\" src=\"https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/uploads\/2023\/10\/ham-datedif-7.jpg\" alt=\"ham-datedif-7\" width=\"800\" height=\"450\" srcset=\"https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/uploads\/2023\/10\/ham-datedif-7.jpg 800w, https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/uploads\/2023\/10\/ham-datedif-7-300x169.jpg 300w, https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/uploads\/2023\/10\/ham-datedif-7-768x432.jpg 768w\" sizes=\"(max-width: 800px) 100vw, 800px\"><\/picture><figcaption id=\"caption-attachment-280530\" class=\"wp-caption-text\">V\u00ed d\u1ee5 d\u00f9ng h\u00e0m NETWORKDAYS \u0111\u1ec3 \u0111\u1ebfm ng\u00e0y l\u00e0m vi\u1ec7c<\/figcaption><\/figure>\n<p>L\u01b0u \u00fd: N\u1ebfu nh\u01b0 b\u1ea1n mu\u1ed1n sao ch\u00e9p c\u00f4ng th\u1ee9c h\u00e0m tr\u00ean qua \u00f4 kh\u00e1c th\u00ec ph\u1ea3i d\u00f9ng tham chi\u1ebfu \u00f4 tuy\u1ec7t \u0111\u1ed1i cho c\u00e1c ng\u00e0y l\u1ec5 \u0111\u1ec3 tr\u00e1nh nh\u1eadn v\u1ec1 k\u1ebft qu\u1ea3 kh\u00f4ng \u0111\u00fang. Ho\u1eb7c b\u1ea1n c\u00f3 th\u1ec3 c\u00e2n nh\u1eafc vi\u1ec7c s\u1eed d\u1ee5ng c\u00f4ng th\u1ee9c m\u1ea3ng \u0111\u1ec3 t\u00ednh to\u00e1n ch\u00ednh x\u00e1c h\u01a1n.<\/p>\n<h3>V\u00ed d\u1ee5 d\u00f9ng h\u00e0m NETWORKDAYS.INTL \u0111\u1ec3 \u0111\u1ebfm ng\u00e0y l\u00e0m vi\u1ec7c<\/h3>\n<p>N\u1ebfu l\u1ecbch l\u00e0m vi\u1ec7c cu\u1ed1i tu\u1ea7n c\u1ee7a b\u1ea1n \u0111\u00e3 b\u1ecb ch\u1ec9nh th\u00ec kh\u00f4ng d\u00f9ng \u0111\u01b0\u1ee3c h\u00e0m DATEDIF \u0111\u1ec3 \u0111\u1ebfm s\u1ed1 ng\u00e0y \u0111i l\u00e0m. M\u00e0 b\u1ea1n ph\u1ea3i d\u00f9ng \u0111\u1ebfn h\u00e0m NETWORKDAYS.INTL. H\u00e0m n\u00e0y gi\u00fap b\u1ea1n \u0111\u01b0\u1ee3c \u0111\u1ebfm s\u1ed1 ng\u00e0y \u0111i l\u00e0m nhanh ch\u00f3ng tr\u00ean Google Sheets d\u1ef1a theo nh\u1eefng ng\u00e0y quy \u0111\u1ecbnh l\u00e0 cu\u1ed1i tu\u1ea7n do b\u1ea1n t\u1ef1 \u0111\u1eb7t ra. C\u00f4ng th\u1ee9c s\u1eed d\u1ee5ng NETWORKDAYS.INTL nh\u01b0 sau:<\/p>\n<p>=NETWORKDAYS.INTL(start_date, end_date, [weekend], [holidays])<\/p>\n<p>Trong c\u00f4ng th\u1ee9c tr\u00ean c\u00f3 nh\u1eefng \u0111\u1ed1i s\u1ed1 nh\u01b0 sau:<\/p>\n<h4>Start_Date v\u00e0 End_Date<\/h4>\n<ul>\n<li style=\"font-weight: 400;\">Start_Date: Ng\u00e0y l\u00e0m \u0111i\u1ec3m b\u1eaft \u0111\u1ea7u.<\/li>\n<li style=\"font-weight: 400;\">End_Date: Ng\u00e0y l\u00e0m \u0111i\u1ec3m k\u1ebft th\u00fac.<\/li>\n<\/ul>\n<p>Ch\u00fa \u00fd: Trong Google Sheet, h\u00e0m NETWORKDAYS.INTL c\u0169ng t\u00ednh ng\u00e0y l\u00e0m \u0111i\u1ec3m b\u1eaft \u0111\u1ea7u v\u00e0 ng\u00e0y l\u00e0m \u0111i\u1ec3m k\u1ebft th\u00fac l\u00e0 ng\u00e0y \u0111i l\u00e0m (ngo\u1ea1i tr\u1eeb n\u1ebfu hai ng\u00e0y n\u00e0y l\u00e0 ng\u00e0y l\u1ec5).<\/p>\n<h4>Weekend<\/h4>\n<p>\u0110\u00e2y l\u00e0 t\u00f9y ch\u1ecdn, n\u1ebfu nh\u01b0 b\u1ea1n b\u1ecf qua th\u00ec th\u1ee9 7 v\u00e0 ng\u00e0y ch\u1ee7 nh\u1eadt \u0111\u01b0\u1ee3c xem l\u00e0 c\u00e1c ng\u00e0y ngh\u1ec9 v\u00e0o cu\u1ed1i tu\u1ea7n. N\u1ebfu c\u1ea7n thi\u1ebft th\u00ec b\u1ea1n c\u00f3 th\u1ec3 t\u00f9y ch\u1ec9nh b\u1eb1ng vi\u1ec7c d\u00f9ng Masks v\u00e0 Numbers.<\/p>\n<h4>Masks<\/h4>\n<p>\u0110\u00e2y l\u00e0 m\u1eabu g\u1ed3m 7 ch\u1eef s\u1ed1 0 v\u00e0 1. S\u1ed1 1 th\u1ec3 hi\u1ec7n 1 ng\u00e0y cu\u1ed1i tu\u1ea7n, c\u00f2n s\u1ed1 0 th\u1ec3 hi\u1ec7n 1 ng\u00e0y l\u00e0m vi\u1ec7c. S\u1ed1 \u0111\u1ea7u ti\u00ean trong m\u1eabu m\u1eb7c \u0111\u1ecbnh lu\u00f4n l\u00e0 th\u1ee9 2, s\u1ed1 cu\u1ed1i c\u00f9ng trong m\u1eabu m\u1eb7c \u0111\u1ecbnh l\u00e0 ng\u00e0y Ch\u1ee7 nh\u1eadt. Masks lu\u00f4n \u0111\u01b0\u1ee3c \u0111\u1eb7t trong d\u1ea5u ngo\u1eb7c k\u00e9p khi c\u00e1c ng\u00e0y ngh\u1ec9 r\u1ea3i r\u00e1c trong m\u1ed9t tu\u1ea7n.<\/p>\n<p>V\u00ed d\u1ee5 m\u1eabu \u201c1100110\u201d c\u00f3 ngh\u0129a l\u00e0 b\u1ea1n l\u00e0m vi\u1ec7c v\u00e0o c\u00e1c ng\u00e0y th\u1ee9 4, th\u1ee9 5, th\u1ee9 6, th\u1ee9 7.<\/p>\n<h4>Numbers<\/h4>\n<p>\u0110\u00e2y l\u00e0 nh\u1eefng con s\u1ed1 v\u00e0 b\u1ea1n c\u00f3 th\u1ec3 d\u00f9ng nh\u1eefng s\u1ed1 c\u00f3 m\u1ed9t ch\u1eef s\u1ed1 t\u1eeb 1 \u0111\u1ebfn 7 \u0111\u1ec3 th\u1ec3 hi\u1ec7n cho 1 c\u1eb7p s\u1ed1 ng\u00e0y cu\u1ed1i tu\u1ea7n \u0111\u00e3 x\u00e1c \u0111\u1ecbnh. M\u1ed7i s\u1ed1 s\u1ebd t\u01b0\u01a1ng \u1ee9ng v\u1edbi hai ng\u00e0y cu\u1ed1i tu\u1ea7n nh\u01b0 sau:<\/p>\n<table>\n<tbody>\n<tr>\n<td>Con s\u1ed1<\/td>\n<td>Ng\u00e0y cu\u1ed1i tu\u1ea7n<\/td>\n<\/tr>\n<tr>\n<td>1<\/td>\n<td>Th\u1ee9 b\u1ea3y, Ch\u1ee7 Nh\u1eadt<\/td>\n<\/tr>\n<tr>\n<td>2<\/td>\n<td>Ch\u1ee7 nh\u1eadt, th\u1ee9 hai<\/td>\n<\/tr>\n<tr>\n<td>3<\/td>\n<td>Th\u1ee9 hai, th\u1ee9 ba<\/td>\n<\/tr>\n<tr>\n<td>4<\/td>\n<td>Th\u1ee9 ba, th\u1ee9 t\u01b0<\/td>\n<\/tr>\n<tr>\n<td>5<\/td>\n<td>Th\u1ee9 t\u01b0, th\u1ee9 n\u0103m<\/td>\n<\/tr>\n<tr>\n<td>6<\/td>\n<td>Th\u1ee9 n\u0103m, th\u1ee9 s\u00e1u<\/td>\n<\/tr>\n<tr>\n<td>7<\/td>\n<td>Th\u1ee9 s\u00e1u, th\u1ee9 b\u1ea3y<\/td>\n<\/tr>\n<\/tbody>\n<\/table>\n<p>Ho\u1eb7c b\u1ea1n c\u0169ng c\u00f3 th\u1ec3 s\u1eed d\u1ee5ng nh\u1eefng s\u1ed1 c\u00f3 2 ch\u1eef s\u1ed1 t\u1eeb 11 \u0111\u1ebfn 17 \u0111\u1ec3 th\u1ec3 hi\u1ec7n 1 ng\u00e0y ngh\u1ec9 trong 1 tu\u1ea7n. Chi ti\u1ebft t\u1eebng s\u1ed1 t\u01b0\u01a1ng \u1ee9ng v\u1edbi ng\u00e0y cu\u1ed1i tu\u1ea7n \u0111\u01b0\u1ee3c th\u1ec3 hi\u1ec7n \u1edf b\u1ea3ng sau:<\/p>\n<table>\n<tbody>\n<tr>\n<td>Con s\u1ed1<\/td>\n<td>Ng\u00e0y cu\u1ed1i tu\u1ea7n<\/td>\n<\/tr>\n<tr>\n<td>11<\/td>\n<td>Ch\u1ee7 nh\u1eadt<\/td>\n<\/tr>\n<tr>\n<td>12<\/td>\n<td>Th\u1ee9 hai<\/td>\n<\/tr>\n<tr>\n<td>13<\/td>\n<td>Th\u1ee9 ba<\/td>\n<\/tr>\n<tr>\n<td>14<\/td>\n<td>Th\u1ee9 t\u01b0<\/td>\n<\/tr>\n<tr>\n<td>15<\/td>\n<td>Th\u1ee9 n\u0103m<\/td>\n<\/tr>\n<tr>\n<td>16<\/td>\n<td>Th\u1ee9 s\u00e1u<\/td>\n<\/tr>\n<tr>\n<td>17<\/td>\n<td>Th\u1ee9 b\u1ea3y<\/td>\n<\/tr>\n<\/tbody>\n<\/table>\n<h4>Holiday<\/h4>\n<p>\u0110\u00e2y l\u00e0 tham s\u1ed1 c\u00f3 th\u1ec3 t\u00f9y ch\u1ec9nh v\u00e0 \u0111\u01b0\u1ee3c d\u00f9ng \u0111\u1ec3 ch\u1ec9 \u0111\u1ecbnh cho ng\u00e0y ngh\u1ec9. Ch\u1ee9c n\u0103ng n\u00e0y nghe c\u00f3 v\u1ebb kh\u00e1 kh\u00f3 hi\u1ec3u. \u0110\u1ea7u ti\u00ean, b\u1ea1n ch\u1ec9 c\u1ea7n n\u1eafm r\u00f5 ng\u00e0y ngh\u1ec9 c\u1ee7a m\u00ecnh. Sau \u0111\u00f3 b\u1ea1n ch\u1ec9 ra c\u00e1c ng\u00e0y m\u00e0 b\u1ea1n quy \u0111\u1ecbnhh l\u00e0 cu\u1ed1i tu\u1ea7n c\u1ee7a m\u00ecnh. N\u1ebfu b\u1ea1n ch\u1ecdn v\u00e0o Masks th\u00ec d\u00e3y s\u1ed1 s\u1ebd l\u00e0 1000001 v\u00e0 h\u00e0m NETWORKDAYS.INTL \u1edf tr\u01b0\u1eddng h\u1ee3p n\u00e0y \u0111\u01b0\u1ee3c th\u1ec3 hi\u1ec7n nh\u01b0 sau:<\/p>\n<p>=NETWORKDAYS.INTL(B2,C2,&#8221;1000001&#8243;)<\/p>\n<p>N\u1ebfu b\u1ea1n mu\u1ed1n m\u00ecnh c\u00f3 2 ng\u00e0y ngh\u1ec9 cu\u1ed1i tu\u1ea7n k\u1ebf ti\u1ebfp nhau th\u00ec c\u00f3 th\u1ec3 d\u00f9ng 1 s\u1ed1 t\u1eeb b\u1ea3ng tr\u00ean, v\u00ed d\u1ee5 nh\u01b0 d\u00f9ng s\u1ed1 2 th\u00ec \u0111\u01b0\u1ee3c c\u00f4ng th\u1ee9c nh\u01b0 sau:<\/p>\n<p>=NETWORKDAYS.INTL(B2, C2, 2)<\/p>\n<p>Ti\u1ebfp theo th\u00ec b\u1ea1n ch\u1ec9 c\u1ea7n b\u1ed5 sung m\u1ed9t \u0111\u1ed1i s\u1ed1 cu\u1ed1i \u0111\u1ec3 tham chi\u1ebfu t\u1edbi nh\u1eefng ng\u00e0y l\u1ec5 \u0111\u00e3 \u0111\u01b0\u1ee3c li\u1ec7t k\u00ea t\u1ea1i c\u1ed9t E v\u00e0 h\u00e0m ho\u00e0n ch\u1ec9nh th\u1ec3 hi\u1ec7n nh\u01b0 sau:<\/p>\n<p>=NETWORKDAYS.INTL(B2,C2,2,$E$2:$E$4)<\/p>\n<figure id=\"attachment_280531\" aria-describedby=\"caption-attachment-280531\" style=\"width: 800px\" class=\"wp-caption aligncenter\"><picture><source srcset=\"https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/webp-express\/webp-images\/uploads\/2023\/10\/ham-datedif-8.jpg.webp 800w, https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/webp-express\/webp-images\/uploads\/2023\/10\/ham-datedif-8-300x169.jpg.webp 300w, https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/webp-express\/webp-images\/uploads\/2023\/10\/ham-datedif-8-768x432.jpg.webp 768w\" sizes=\"(max-width: 800px) 100vw, 800px\" type=\"image\/webp\"><img loading=\"lazy\" decoding=\"async\" class=\"wp-image-280531 size-full webpexpress-processed\" src=\"https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/uploads\/2023\/10\/ham-datedif-8.jpg\" alt=\"ham-datedif-8\" width=\"800\" height=\"450\" srcset=\"https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/uploads\/2023\/10\/ham-datedif-8.jpg 800w, https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/uploads\/2023\/10\/ham-datedif-8-300x169.jpg 300w, https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/uploads\/2023\/10\/ham-datedif-8-768x432.jpg 768w\" sizes=\"(max-width: 800px) 100vw, 800px\"><\/picture><figcaption id=\"caption-attachment-280531\" class=\"wp-caption-text\">V\u00ed d\u1ee5 d\u00f9ng h\u00e0m NETWORKDAYS.INTL \u0111\u1ec3 \u0111\u1ebfm ng\u00e0y l\u00e0m vi\u1ec7c<\/figcaption><\/figure>\n<h2>C\u00e1ch d\u00f9ng h\u00e0m DATEDIF t\u00ednh s\u1ed1 th\u00e1ng gi\u1eefa 2 ng\u00e0y trong Google Sheet<\/h2>\n<p>N\u1ebfu b\u1ea1n mu\u1ed1n t\u00ednh ch\u00eanh l\u1ec7ch s\u1ed1 th\u00e1ng gi\u1eefa hai ng\u00e0y th\u00ec c\u00f3 th\u1ec3 d\u00f9ng h\u00e0m DATEDIF \u0111\u1ec3 t\u00ednh to\u00e1n nh\u01b0 nh\u1eefng v\u00ed d\u1ee5 sau \u0111\u00e2y:<\/p>\n<h3>V\u00ed d\u1ee5 t\u00ednh to\u00e0n b\u1ed9 s\u1ed1 th\u00e1ng gi\u1eefa hai ng\u00e0y<\/h3>\n<p>Trong b\u1ea3ng sau \u0111\u00e2y, Start_date l\u00e0 \u0111\u1ed1i s\u1ed1 \u0111\u1eb7t \u0111\u1ea7u ti\u00ean, sau \u0111\u00f3 \u0111\u1ebfn End_date v\u00e0 k\u00fd hi\u1ec7u \u201cM\u201d l\u00e0 \u0111\u01a1n v\u1ecb Months, \u0111\u01b0\u1ee3c coi l\u00e0 \u0111\u1ed1i s\u1ed1 cu\u1ed1i c\u00f9ng. Ta s\u1ebd c\u00f3 c\u00f4ng th\u1ee9c t\u00ednh s\u1ed1 th\u00e1ng \u0111\u1ea7y \u0111\u1ee7 gi\u1eefa 2 ng\u00e0y nh\u01b0 sau:<\/p>\n<p>=DATEDIF(A2,B2,&#8221;M&#8221;)<\/p>\n<figure id=\"attachment_280532\" aria-describedby=\"caption-attachment-280532\" style=\"width: 800px\" class=\"wp-caption aligncenter\"><picture><source srcset=\"https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/webp-express\/webp-images\/uploads\/2023\/10\/ham-datedif-9.jpg.webp 800w, https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/webp-express\/webp-images\/uploads\/2023\/10\/ham-datedif-9-300x169.jpg.webp 300w, https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/webp-express\/webp-images\/uploads\/2023\/10\/ham-datedif-9-768x432.jpg.webp 768w\" sizes=\"(max-width: 800px) 100vw, 800px\" type=\"image\/webp\"><img loading=\"lazy\" decoding=\"async\" class=\"wp-image-280532 size-full webpexpress-processed\" src=\"https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/uploads\/2023\/10\/ham-datedif-9.jpg\" alt=\"ham-datedif-9\" width=\"800\" height=\"450\" srcset=\"https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/uploads\/2023\/10\/ham-datedif-9.jpg 800w, https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/uploads\/2023\/10\/ham-datedif-9-300x169.jpg 300w, https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/uploads\/2023\/10\/ham-datedif-9-768x432.jpg 768w\" sizes=\"(max-width: 800px) 100vw, 800px\"><\/picture><figcaption id=\"caption-attachment-280532\" class=\"wp-caption-text\">V\u00ed d\u1ee5 t\u00ednh s\u1ed1 th\u00e1ng \u0111\u1ea7y \u0111\u1ee7 gi\u1eefa 2 ng\u00e0y<\/figcaption><\/figure>\n<p>Ch\u00fa \u00fd: B\u1ea1n c\u00f3 th\u1ec3 d\u00f9ng h\u00e0m ARRAUFORMULA \u0111\u1ec3 \u0111\u1ebfm c\u00f9ng l\u00fac s\u1ed1 th\u00e1ng tr\u00ean to\u00e0n b\u1ed9 h\u00e0ng nh\u01b0 sau:<\/p>\n<p>=ARRAYFORMULA(DATEDIF(A2:A13, B2:B13,&#8221;M&#8221;))<\/p>\n<h3>V\u00ed d\u1ee5 \u0111\u1ebfm s\u1ed1 th\u00e1ng v\u00e0 lo\u1ea1i tr\u1eeb n\u0103m<\/h3>\n<p>B\u1ea1n kh\u00f4ng c\u1ea7n t\u00ednh s\u1ed1 l\u01b0\u1ee3ng th\u00e1ng trong c\u00e1c n\u0103m gi\u1eefa hai ng\u00e0y kh\u1edfi \u0111i\u1ec3m v\u00e0 ng\u00e0y t\u1edbi h\u1ea1n v\u00e0 c\u00f4ng th\u1ee9c DATEDIF c\u00f3 th\u1ec3 gi\u00fap b\u1ea1n t\u00ednh to\u00e1n nhanh ch\u00f3ng. B\u1ea1n ch\u1ec9 c\u1ea7n d\u00f9ng \u0111\u01a1n v\u1ecb l\u00e0 \u201cYM\u201d l\u00e0 c\u00f4ng th\u1ee9c n\u00e0y t\u1ef1 \u0111\u1ed9ng tr\u1eeb \u0111i n\u0103m tr\u01b0\u1edbc. Ti\u1ebfp \u0111\u00f3 s\u1ebd t\u00ednh s\u1ed1 l\u01b0\u1ee3ng th\u00e1ng gi\u1eefa 2 ng\u00e0y v\u1edbi c\u00f4ng th\u1ee9c h\u00e0m nh\u01b0 sau:<\/p>\n<p>=DATEDIF(A2,B2,&#8221;YM&#8221;)<\/p>\n<figure id=\"attachment_280533\" aria-describedby=\"caption-attachment-280533\" style=\"width: 800px\" class=\"wp-caption aligncenter\"><picture><source srcset=\"https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/webp-express\/webp-images\/uploads\/2023\/10\/ham-datedif-10.jpg.webp 800w, https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/webp-express\/webp-images\/uploads\/2023\/10\/ham-datedif-10-300x169.jpg.webp 300w, https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/webp-express\/webp-images\/uploads\/2023\/10\/ham-datedif-10-768x432.jpg.webp 768w\" sizes=\"(max-width: 800px) 100vw, 800px\" type=\"image\/webp\"><img loading=\"lazy\" decoding=\"async\" class=\"wp-image-280533 size-full webpexpress-processed\" src=\"https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/uploads\/2023\/10\/ham-datedif-10.jpg\" alt=\"ham-datedif-10\" width=\"800\" height=\"450\" srcset=\"https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/uploads\/2023\/10\/ham-datedif-10.jpg 800w, https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/uploads\/2023\/10\/ham-datedif-10-300x169.jpg 300w, https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/uploads\/2023\/10\/ham-datedif-10-768x432.jpg 768w\" sizes=\"(max-width: 800px) 100vw, 800px\"><\/picture><figcaption id=\"caption-attachment-280533\" class=\"wp-caption-text\">V\u00ed d\u1ee5 \u0111\u1ebfm s\u1ed1 th\u00e1ng v\u00e0 b\u1ecf qua n\u0103m<\/figcaption><\/figure>\n<h2>C\u00e1ch d\u00f9ng h\u00e0m DATEDIF t\u00ednh s\u1ed1 l\u01b0\u1ee3ng n\u0103m gi\u1eefa 2 ng\u00e0y trong Google Sheet<\/h2>\n<p>C\u00e1ch d\u00f9ng cu\u1ed1i c\u00f9ng m\u00e0 b\u1ea1n c\u1ea7n t\u00ecm hi\u1ec3u v\u1ec1 h\u00e0m DATEDIF ch\u00ednh l\u00e0 s\u1eed d\u1ee5ng h\u00e0m \u0111\u1ec3 t\u00ednh s\u1ed1 n\u0103m ch\u00eanh l\u1ec7ch gi\u1eefa 2 ng\u00e0y. Sau \u0111\u00e2y l\u00e0 v\u00ed d\u1ee5 t\u00ednh s\u1ed1 l\u01b0\u1ee3ng n\u0103m c\u1ee7a nh\u1eefng c\u1eb7p \u0111\u00e3 c\u01b0\u1edbi, c\u0103n c\u1ee9 theo ng\u00e0y c\u01b0\u1edbi \u0111\u1ebfn ng\u00e0y hi\u1ec7n t\u1ea1i.<\/p>\n<p>Trong tr\u01b0\u1eddng h\u1ee3p n\u00e0y th\u00ec ch\u00fang ta s\u1ebd d\u00f9ng \u0111\u01a1n v\u1ecb \u201cY\u201d cho c\u00f4ng th\u1ee9c h\u00e0m nh\u01b0 sau:<\/p>\n<p>=DATEDIF(A2, B2,&#8221;Y&#8221;)<\/p>\n<figure id=\"attachment_280534\" aria-describedby=\"caption-attachment-280534\" style=\"width: 800px\" class=\"wp-caption aligncenter\"><picture><source srcset=\"https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/webp-express\/webp-images\/uploads\/2023\/10\/ham-datedif-11.jpg.webp 800w, https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/webp-express\/webp-images\/uploads\/2023\/10\/ham-datedif-11-300x169.jpg.webp 300w, https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/webp-express\/webp-images\/uploads\/2023\/10\/ham-datedif-11-768x432.jpg.webp 768w\" sizes=\"(max-width: 800px) 100vw, 800px\" type=\"image\/webp\"><img loading=\"lazy\" decoding=\"async\" class=\"wp-image-280534 size-full webpexpress-processed\" src=\"https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/uploads\/2023\/10\/ham-datedif-11.jpg\" alt=\"ham-datedif-11\" width=\"800\" height=\"450\" srcset=\"https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/uploads\/2023\/10\/ham-datedif-11.jpg 800w, https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/uploads\/2023\/10\/ham-datedif-11-300x169.jpg 300w, https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/uploads\/2023\/10\/ham-datedif-11-768x432.jpg 768w\" sizes=\"(max-width: 800px) 100vw, 800px\"><\/picture><figcaption id=\"caption-attachment-280534\" class=\"wp-caption-text\">C\u00e1ch d\u00f9ng h\u00e0m t\u00ednh s\u1ed1 n\u0103m gi\u1eefa 2 ng\u00e0y trong Google Sheet<\/figcaption><\/figure>\n<p>To\u00e0n b\u1ed9 b\u00e0i vi\u1ebft tr\u00ean \u0111\u00e3 h\u01b0\u1edbng d\u1eabn cho m\u1ecdi ng\u01b0\u1eddi c\u00e1ch s\u1eed d\u1ee5ng h\u00e0m DATEDIF \u0111\u1ec3 t\u00ednh ch\u00eanh l\u1ec7ch gi\u1eefa 2 ng\u00e0y trong Google Sheet. H\u00e0m n\u00e0y s\u1ebd gi\u00fap m\u1ecdi ng\u01b0\u1eddi l\u00e0m vi\u1ec7c hi\u1ec7u qu\u1ea3 h\u01a1n v\u1edbi nh\u1eefng b\u1ea3ng d\u1eef li\u1ec7u c\u00f3 ng\u00e0y\/ th\u00e1ng\/ n\u0103m v\u00e0 t\u00ednh to\u00e1n theo c\u00e1ch nhanh g\u1ecdn nh\u1ea5t.<\/p>\n<p>Tham kh\u1ea3o b\u00e0i vi\u1ebft li\u00ean quan:<\/p>\n<ul>\n<li style=\"font-weight: 400;\"><a href=\"https:\/\/hoanghamobile.com\/tin-tuc\/cac-ham-excel-co-ban-ma-ban-can-nam-ro\/\">C\u00e1c h\u00e0m excel c\u01a1 b\u1ea3n m\u00e0 b\u1ea1n c\u1ea7n n\u1eafm r\u00f5<\/a><\/li>\n<li style=\"font-weight: 400;\"><a href=\"https:\/\/hoanghamobile.com\/tin-tuc\/ham-if-and\/\">C\u00e1ch d\u00f9ng h\u00e0m IF k\u1ebft h\u1ee3p h\u00e0m AND trong Excel c\u00f3 v\u00ed d\u1ee5 minh h\u1ecda<\/a><\/li>\n<\/ul>\n","protected":false},"excerpt":{"rendered":"<p>Khi s\u1eed d\u1ee5ng Google Sheet c\u00f3 c\u00e1c d\u1eef li\u1ec7u li\u00ean quan \u0111\u1ebfn ng\u00e0y\/ th\u00e1ng, kh\u00e1 nhi\u1ec1u ng\u01b0\u1eddi g\u1eb7p h\u00e0m DATEDIF nh\u01b0ng v\u1eabn ch\u01b0a c\u00e1ch \u00e1p d\u1ee5ng nh\u01b0 th\u1ebf n\u00e0o. \u0110\u1ec3 s\u1eed d\u1ee5ng h\u00e0m n\u00e0y hi\u1ec7u qu\u1ea3 h\u01a1n trong c\u00f4ng vi\u1ec7c, b\u1ea1n h\u00e3y theo d\u00f5i b\u00e0i vi\u1ebft sau \u0111\u1ec3 bi\u1ebft \u0111\u00e2y l\u00e0 h\u00e0m g\u00ec v\u00e0 c\u00f4ng [&hellip;]<\/p>\n","protected":false},"author":102,"featured_media":283078,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[28955,16,412],"tags":[],"class_list":["post-280498","post","type-post","status-publish","format-standard","has-post-thumbnail","hentry","category-excel","category-thu-thuat","category-thu-thuat-may-tinh"],"yoast_head":"<!-- This site is optimized with the Yoast SEO Premium plugin v24.2 (Yoast SEO v24.2) - https:\/\/yoast.com\/wordpress\/plugins\/seo\/ -->\n<title>D\u00f9ng h\u00e0m DATEDIF t\u00ednh ch\u00eanh l\u1ec7ch gi\u1eefa 2 ng\u00e0y trong Sheet<\/title>\n<meta name=\"description\" content=\"Hi\u1ec7n nay nhi\u1ec1u ng\u01b0\u1eddi \u0111ang s\u1eed d\u1ee5ng h\u00e0m DATEDIF \u0111\u1ec3 t\u00ednh m\u1ee9c ch\u00eanh l\u1ec7ch gi\u1eefa hai th\u1eddi \u0111i\u1ec3m nhanh h\u01a1n. B\u00e0i vi\u1ebft sau s\u1ebd h\u01b0\u1edbng d\u1eabn.\" \/>\n<meta name=\"robots\" content=\"index, follow, max-snippet:-1, max-image-preview:large, max-video-preview:-1\" \/>\n<link rel=\"canonical\" href=\"https:\/\/hoanghamobile.com\/tin-tuc\/ham-datedif\/\" \/>\n<meta property=\"og:locale\" content=\"vi_VN\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"C\u00e1ch d\u00f9ng h\u00e0m DATEDIF t\u00ednh ch\u00eanh l\u1ec7ch gi\u1eefa 2 ng\u00e0y trong Google Sheet\" \/>\n<meta property=\"og:description\" content=\"Hi\u1ec7n nay nhi\u1ec1u ng\u01b0\u1eddi \u0111ang s\u1eed d\u1ee5ng h\u00e0m DATEDIF \u0111\u1ec3 t\u00ednh m\u1ee9c ch\u00eanh l\u1ec7ch gi\u1eefa hai th\u1eddi \u0111i\u1ec3m nhanh h\u01a1n. B\u00e0i vi\u1ebft sau s\u1ebd h\u01b0\u1edbng d\u1eabn.\" \/>\n<meta property=\"og:url\" content=\"https:\/\/hoanghamobile.com\/tin-tuc\/ham-datedif\/\" \/>\n<meta property=\"og:site_name\" content=\"Tin t\u1ee9c c\u00f4ng ngh\u1ec7 - HoangHaMobile\" \/>\n<meta property=\"article:publisher\" content=\"https:\/\/www.facebook.com\/hoanghamobilecom\" \/>\n<meta property=\"article:author\" content=\"https:\/\/www.facebook.com\/hoanghamobilecom\" \/>\n<meta property=\"article:published_time\" content=\"2023-11-07T16:48:11+00:00\" \/>\n<meta property=\"og:image\" content=\"https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/uploads\/2023\/11\/ham-datedif-thumb.jpg\" \/>\n\t<meta property=\"og:image:width\" content=\"1200\" \/>\n\t<meta property=\"og:image:height\" content=\"628\" \/>\n\t<meta property=\"og:image:type\" content=\"image\/jpeg\" \/>\n<meta name=\"author\" content=\"Nguy\u1ec5n Xu\u00e2n Thi\u00ean\" \/>\n<meta name=\"twitter:card\" content=\"summary_large_image\" \/>\n<meta name=\"twitter:label1\" content=\"\u0110\u01b0\u1ee3c vi\u1ebft b\u1edfi\" \/>\n\t<meta name=\"twitter:data1\" content=\"Nguy\u1ec5n Xu\u00e2n Thi\u00ean\" \/>\n\t<meta name=\"twitter:label2\" content=\"\u01af\u1edbc t\u00ednh th\u1eddi gian \u0111\u1ecdc\" \/>\n\t<meta name=\"twitter:data2\" content=\"14 ph\u00fat\" \/>\n<script type=\"application\/ld+json\" class=\"yoast-schema-graph\">{\"@context\":\"https:\/\/schema.org\",\"@graph\":[{\"@type\":\"Article\",\"@id\":\"https:\/\/hoanghamobile.com\/tin-tuc\/ham-datedif\/#article\",\"isPartOf\":{\"@id\":\"https:\/\/hoanghamobile.com\/tin-tuc\/ham-datedif\/\"},\"author\":{\"name\":\"Nguy\u1ec5n Xu\u00e2n Thi\u00ean\",\"@id\":\"https:\/\/hoanghamobile.com\/tin-tuc\/#\/schema\/person\/26499da0a8947cbc1d286a6c25f0d1a4\"},\"headline\":\"C\u00e1ch d\u00f9ng h\u00e0m DATEDIF t\u00ednh ch\u00eanh l\u1ec7ch gi\u1eefa 2 ng\u00e0y trong Google Sheet\",\"datePublished\":\"2023-11-07T16:48:11+00:00\",\"dateModified\":\"2023-11-07T16:48:11+00:00\",\"mainEntityOfPage\":{\"@id\":\"https:\/\/hoanghamobile.com\/tin-tuc\/ham-datedif\/\"},\"wordCount\":3186,\"commentCount\":0,\"publisher\":{\"@id\":\"https:\/\/hoanghamobile.com\/tin-tuc\/#organization\"},\"image\":{\"@id\":\"https:\/\/hoanghamobile.com\/tin-tuc\/ham-datedif\/#primaryimage\"},\"thumbnailUrl\":\"https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/uploads\/2023\/11\/ham-datedif-thumb.jpg\",\"articleSection\":[\"Excel\",\"Th\u1ee7 thu\u1eadt\",\"Th\u1ee7 thu\u1eadt m\u00e1y t\u00ednh\"],\"inLanguage\":\"vi\",\"potentialAction\":[{\"@type\":\"CommentAction\",\"name\":\"Comment\",\"target\":[\"https:\/\/hoanghamobile.com\/tin-tuc\/ham-datedif\/#respond\"]}],\"copyrightYear\":\"2023\",\"copyrightHolder\":{\"@id\":\"https:\/\/hoanghamobile.com\/tin-tuc\/#organization\"}},{\"@type\":\"WebPage\",\"@id\":\"https:\/\/hoanghamobile.com\/tin-tuc\/ham-datedif\/\",\"url\":\"https:\/\/hoanghamobile.com\/tin-tuc\/ham-datedif\/\",\"name\":\"D\u00f9ng h\u00e0m DATEDIF t\u00ednh ch\u00eanh l\u1ec7ch gi\u1eefa 2 ng\u00e0y trong Sheet\",\"isPartOf\":{\"@id\":\"https:\/\/hoanghamobile.com\/tin-tuc\/#website\"},\"primaryImageOfPage\":{\"@id\":\"https:\/\/hoanghamobile.com\/tin-tuc\/ham-datedif\/#primaryimage\"},\"image\":{\"@id\":\"https:\/\/hoanghamobile.com\/tin-tuc\/ham-datedif\/#primaryimage\"},\"thumbnailUrl\":\"https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/uploads\/2023\/11\/ham-datedif-thumb.jpg\",\"datePublished\":\"2023-11-07T16:48:11+00:00\",\"dateModified\":\"2023-11-07T16:48:11+00:00\",\"description\":\"Hi\u1ec7n nay nhi\u1ec1u ng\u01b0\u1eddi \u0111ang s\u1eed d\u1ee5ng h\u00e0m DATEDIF \u0111\u1ec3 t\u00ednh m\u1ee9c ch\u00eanh l\u1ec7ch gi\u1eefa hai th\u1eddi \u0111i\u1ec3m nhanh h\u01a1n. B\u00e0i vi\u1ebft sau s\u1ebd h\u01b0\u1edbng d\u1eabn.\",\"breadcrumb\":{\"@id\":\"https:\/\/hoanghamobile.com\/tin-tuc\/ham-datedif\/#breadcrumb\"},\"inLanguage\":\"vi\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/hoanghamobile.com\/tin-tuc\/ham-datedif\/\"]}]},{\"@type\":\"ImageObject\",\"inLanguage\":\"vi\",\"@id\":\"https:\/\/hoanghamobile.com\/tin-tuc\/ham-datedif\/#primaryimage\",\"url\":\"https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/uploads\/2023\/11\/ham-datedif-thumb.jpg\",\"contentUrl\":\"https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/uploads\/2023\/11\/ham-datedif-thumb.jpg\",\"width\":1200,\"height\":628,\"caption\":\"ham-datedif-thumb\"},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/hoanghamobile.com\/tin-tuc\/ham-datedif\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Trang ch\u1ee7\",\"item\":\"https:\/\/hoanghamobile.com\/tin-tuc\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"Th\u1ee7 thu\u1eadt\",\"item\":\"https:\/\/hoanghamobile.com\/tin-tuc\/category\/thu-thuat\/\"},{\"@type\":\"ListItem\",\"position\":3,\"name\":\"C\u00e1ch d\u00f9ng h\u00e0m DATEDIF t\u00ednh ch\u00eanh l\u1ec7ch gi\u1eefa 2 ng\u00e0y trong Google Sheet\"}]},{\"@type\":\"WebSite\",\"@id\":\"https:\/\/hoanghamobile.com\/tin-tuc\/#website\",\"url\":\"https:\/\/hoanghamobile.com\/tin-tuc\/\",\"name\":\"Tin t\u1ee9c c\u00f4ng ngh\u1ec7 - HoangHaMobile\",\"description\":\"\",\"publisher\":{\"@id\":\"https:\/\/hoanghamobile.com\/tin-tuc\/#organization\"},\"potentialAction\":[{\"@type\":\"SearchAction\",\"target\":{\"@type\":\"EntryPoint\",\"urlTemplate\":\"https:\/\/hoanghamobile.com\/tin-tuc\/?s={search_term_string}\"},\"query-input\":{\"@type\":\"PropertyValueSpecification\",\"valueRequired\":true,\"valueName\":\"search_term_string\"}}],\"inLanguage\":\"vi\"},{\"@type\":\"Organization\",\"@id\":\"https:\/\/hoanghamobile.com\/tin-tuc\/#organization\",\"name\":\"Tin t\u1ee9c c\u00f4ng ngh\u1ec7 - HoangHaMobile\",\"url\":\"https:\/\/hoanghamobile.com\/tin-tuc\/\",\"logo\":{\"@type\":\"ImageObject\",\"inLanguage\":\"vi\",\"@id\":\"https:\/\/hoanghamobile.com\/tin-tuc\/#\/schema\/logo\/image\/\",\"url\":\"https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/uploads\/2021\/12\/logo-text.png\",\"contentUrl\":\"https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/uploads\/2021\/12\/logo-text.png\",\"width\":256,\"height\":37,\"caption\":\"Tin t\u1ee9c c\u00f4ng ngh\u1ec7 - HoangHaMobile\"},\"image\":{\"@id\":\"https:\/\/hoanghamobile.com\/tin-tuc\/#\/schema\/logo\/image\/\"},\"sameAs\":[\"https:\/\/www.facebook.com\/hoanghamobilecom\"]},{\"@type\":\"Person\",\"@id\":\"https:\/\/hoanghamobile.com\/tin-tuc\/#\/schema\/person\/26499da0a8947cbc1d286a6c25f0d1a4\",\"name\":\"Nguy\u1ec5n Xu\u00e2n Thi\u00ean\",\"image\":{\"@type\":\"ImageObject\",\"inLanguage\":\"vi\",\"@id\":\"https:\/\/hoanghamobile.com\/tin-tuc\/#\/schema\/person\/image\/\",\"url\":\"https:\/\/secure.gravatar.com\/avatar\/5e5cc5b9fee69402140e5b8ea8828660?s=96&d=mm&r=g\",\"contentUrl\":\"https:\/\/secure.gravatar.com\/avatar\/5e5cc5b9fee69402140e5b8ea8828660?s=96&d=mm&r=g\",\"caption\":\"Nguy\u1ec5n Xu\u00e2n Thi\u00ean\"},\"description\":\"Ch\u00e0o c\u00e1c b\u1ea1n, m\u00ecnh l\u00e0 Xu\u00e2n Thi\u00ean. Trong k\u1ef7 nguy\u00ean s\u1ed1 thay \u0111\u1ed5i t\u1eebng gi\u1edd, m\u00ecnh \u1edf \u0111\u00e2y \u0111\u1ec3 c\u00f9ng b\u1ea1n c\u1eadp nh\u1eadt v\u00e0 ph\u00e2n t\u00edch nh\u1eefng chuy\u1ec3n \u0111\u1ed9ng m\u1edbi nh\u1ea5t c\u1ee7a th\u1ebf gi\u1edbi c\u00f4ng ngh\u1ec7. B\u1eb1ng s\u1ef1 am hi\u1ec3u v\u1ec1 h\u1ec7 sinh th\u00e1i c\u00e1c s\u1ea3n ph\u1ea9m c\u00f4ng ngh\u1ec7 hi\u1ec7n nay, m\u00ecnh cam k\u1ebft mang \u0111\u1ebfn cho b\u1ea1n nh\u1eefng g\u00f3c nh\u00ecn tr\u1ef1c quan, h\u1ed7 tr\u1ee3 b\u1ea1n l\u00e0m ch\u1ee7 c\u00f4ng ngh\u1ec7 m\u1ed9t c\u00e1ch th\u00f4ng minh nh\u1ea5t.\",\"sameAs\":[\"https:\/\/www.facebook.com\/hoanghamobilecom\"],\"url\":\"https:\/\/hoanghamobile.com\/tin-tuc\/author\/nguyen-xuan-thien\/\"}]}<\/script>\n<!-- \/ Yoast SEO Premium plugin. -->","yoast_head_json":{"title":"D\u00f9ng h\u00e0m DATEDIF t\u00ednh ch\u00eanh l\u1ec7ch gi\u1eefa 2 ng\u00e0y trong Sheet","description":"Hi\u1ec7n nay nhi\u1ec1u ng\u01b0\u1eddi \u0111ang s\u1eed d\u1ee5ng h\u00e0m DATEDIF \u0111\u1ec3 t\u00ednh m\u1ee9c ch\u00eanh l\u1ec7ch gi\u1eefa hai th\u1eddi \u0111i\u1ec3m nhanh h\u01a1n. B\u00e0i vi\u1ebft sau s\u1ebd h\u01b0\u1edbng d\u1eabn.","robots":{"index":"index","follow":"follow","max-snippet":"max-snippet:-1","max-image-preview":"max-image-preview:large","max-video-preview":"max-video-preview:-1"},"canonical":"https:\/\/hoanghamobile.com\/tin-tuc\/ham-datedif\/","og_locale":"vi_VN","og_type":"article","og_title":"C\u00e1ch d\u00f9ng h\u00e0m DATEDIF t\u00ednh ch\u00eanh l\u1ec7ch gi\u1eefa 2 ng\u00e0y trong Google Sheet","og_description":"Hi\u1ec7n nay nhi\u1ec1u ng\u01b0\u1eddi \u0111ang s\u1eed d\u1ee5ng h\u00e0m DATEDIF \u0111\u1ec3 t\u00ednh m\u1ee9c ch\u00eanh l\u1ec7ch gi\u1eefa hai th\u1eddi \u0111i\u1ec3m nhanh h\u01a1n. B\u00e0i vi\u1ebft sau s\u1ebd h\u01b0\u1edbng d\u1eabn.","og_url":"https:\/\/hoanghamobile.com\/tin-tuc\/ham-datedif\/","og_site_name":"Tin t\u1ee9c c\u00f4ng ngh\u1ec7 - HoangHaMobile","article_publisher":"https:\/\/www.facebook.com\/hoanghamobilecom","article_author":"https:\/\/www.facebook.com\/hoanghamobilecom","article_published_time":"2023-11-07T16:48:11+00:00","og_image":[{"width":1200,"height":628,"url":"https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/uploads\/2023\/11\/ham-datedif-thumb.jpg","type":"image\/jpeg"}],"author":"Nguy\u1ec5n Xu\u00e2n Thi\u00ean","twitter_card":"summary_large_image","twitter_misc":{"\u0110\u01b0\u1ee3c vi\u1ebft b\u1edfi":"Nguy\u1ec5n Xu\u00e2n Thi\u00ean","\u01af\u1edbc t\u00ednh th\u1eddi gian \u0111\u1ecdc":"14 ph\u00fat"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"Article","@id":"https:\/\/hoanghamobile.com\/tin-tuc\/ham-datedif\/#article","isPartOf":{"@id":"https:\/\/hoanghamobile.com\/tin-tuc\/ham-datedif\/"},"author":{"name":"Nguy\u1ec5n Xu\u00e2n Thi\u00ean","@id":"https:\/\/hoanghamobile.com\/tin-tuc\/#\/schema\/person\/26499da0a8947cbc1d286a6c25f0d1a4"},"headline":"C\u00e1ch d\u00f9ng h\u00e0m DATEDIF t\u00ednh ch\u00eanh l\u1ec7ch gi\u1eefa 2 ng\u00e0y trong Google Sheet","datePublished":"2023-11-07T16:48:11+00:00","dateModified":"2023-11-07T16:48:11+00:00","mainEntityOfPage":{"@id":"https:\/\/hoanghamobile.com\/tin-tuc\/ham-datedif\/"},"wordCount":3186,"commentCount":0,"publisher":{"@id":"https:\/\/hoanghamobile.com\/tin-tuc\/#organization"},"image":{"@id":"https:\/\/hoanghamobile.com\/tin-tuc\/ham-datedif\/#primaryimage"},"thumbnailUrl":"https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/uploads\/2023\/11\/ham-datedif-thumb.jpg","articleSection":["Excel","Th\u1ee7 thu\u1eadt","Th\u1ee7 thu\u1eadt m\u00e1y t\u00ednh"],"inLanguage":"vi","potentialAction":[{"@type":"CommentAction","name":"Comment","target":["https:\/\/hoanghamobile.com\/tin-tuc\/ham-datedif\/#respond"]}],"copyrightYear":"2023","copyrightHolder":{"@id":"https:\/\/hoanghamobile.com\/tin-tuc\/#organization"}},{"@type":"WebPage","@id":"https:\/\/hoanghamobile.com\/tin-tuc\/ham-datedif\/","url":"https:\/\/hoanghamobile.com\/tin-tuc\/ham-datedif\/","name":"D\u00f9ng h\u00e0m DATEDIF t\u00ednh ch\u00eanh l\u1ec7ch gi\u1eefa 2 ng\u00e0y trong Sheet","isPartOf":{"@id":"https:\/\/hoanghamobile.com\/tin-tuc\/#website"},"primaryImageOfPage":{"@id":"https:\/\/hoanghamobile.com\/tin-tuc\/ham-datedif\/#primaryimage"},"image":{"@id":"https:\/\/hoanghamobile.com\/tin-tuc\/ham-datedif\/#primaryimage"},"thumbnailUrl":"https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/uploads\/2023\/11\/ham-datedif-thumb.jpg","datePublished":"2023-11-07T16:48:11+00:00","dateModified":"2023-11-07T16:48:11+00:00","description":"Hi\u1ec7n nay nhi\u1ec1u ng\u01b0\u1eddi \u0111ang s\u1eed d\u1ee5ng h\u00e0m DATEDIF \u0111\u1ec3 t\u00ednh m\u1ee9c ch\u00eanh l\u1ec7ch gi\u1eefa hai th\u1eddi \u0111i\u1ec3m nhanh h\u01a1n. B\u00e0i vi\u1ebft sau s\u1ebd h\u01b0\u1edbng d\u1eabn.","breadcrumb":{"@id":"https:\/\/hoanghamobile.com\/tin-tuc\/ham-datedif\/#breadcrumb"},"inLanguage":"vi","potentialAction":[{"@type":"ReadAction","target":["https:\/\/hoanghamobile.com\/tin-tuc\/ham-datedif\/"]}]},{"@type":"ImageObject","inLanguage":"vi","@id":"https:\/\/hoanghamobile.com\/tin-tuc\/ham-datedif\/#primaryimage","url":"https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/uploads\/2023\/11\/ham-datedif-thumb.jpg","contentUrl":"https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/uploads\/2023\/11\/ham-datedif-thumb.jpg","width":1200,"height":628,"caption":"ham-datedif-thumb"},{"@type":"BreadcrumbList","@id":"https:\/\/hoanghamobile.com\/tin-tuc\/ham-datedif\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Trang ch\u1ee7","item":"https:\/\/hoanghamobile.com\/tin-tuc\/"},{"@type":"ListItem","position":2,"name":"Th\u1ee7 thu\u1eadt","item":"https:\/\/hoanghamobile.com\/tin-tuc\/category\/thu-thuat\/"},{"@type":"ListItem","position":3,"name":"C\u00e1ch d\u00f9ng h\u00e0m DATEDIF t\u00ednh ch\u00eanh l\u1ec7ch gi\u1eefa 2 ng\u00e0y trong Google Sheet"}]},{"@type":"WebSite","@id":"https:\/\/hoanghamobile.com\/tin-tuc\/#website","url":"https:\/\/hoanghamobile.com\/tin-tuc\/","name":"Tin t\u1ee9c c\u00f4ng ngh\u1ec7 - HoangHaMobile","description":"","publisher":{"@id":"https:\/\/hoanghamobile.com\/tin-tuc\/#organization"},"potentialAction":[{"@type":"SearchAction","target":{"@type":"EntryPoint","urlTemplate":"https:\/\/hoanghamobile.com\/tin-tuc\/?s={search_term_string}"},"query-input":{"@type":"PropertyValueSpecification","valueRequired":true,"valueName":"search_term_string"}}],"inLanguage":"vi"},{"@type":"Organization","@id":"https:\/\/hoanghamobile.com\/tin-tuc\/#organization","name":"Tin t\u1ee9c c\u00f4ng ngh\u1ec7 - HoangHaMobile","url":"https:\/\/hoanghamobile.com\/tin-tuc\/","logo":{"@type":"ImageObject","inLanguage":"vi","@id":"https:\/\/hoanghamobile.com\/tin-tuc\/#\/schema\/logo\/image\/","url":"https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/uploads\/2021\/12\/logo-text.png","contentUrl":"https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/uploads\/2021\/12\/logo-text.png","width":256,"height":37,"caption":"Tin t\u1ee9c c\u00f4ng ngh\u1ec7 - HoangHaMobile"},"image":{"@id":"https:\/\/hoanghamobile.com\/tin-tuc\/#\/schema\/logo\/image\/"},"sameAs":["https:\/\/www.facebook.com\/hoanghamobilecom"]},{"@type":"Person","@id":"https:\/\/hoanghamobile.com\/tin-tuc\/#\/schema\/person\/26499da0a8947cbc1d286a6c25f0d1a4","name":"Nguy\u1ec5n Xu\u00e2n Thi\u00ean","image":{"@type":"ImageObject","inLanguage":"vi","@id":"https:\/\/hoanghamobile.com\/tin-tuc\/#\/schema\/person\/image\/","url":"https:\/\/secure.gravatar.com\/avatar\/5e5cc5b9fee69402140e5b8ea8828660?s=96&d=mm&r=g","contentUrl":"https:\/\/secure.gravatar.com\/avatar\/5e5cc5b9fee69402140e5b8ea8828660?s=96&d=mm&r=g","caption":"Nguy\u1ec5n Xu\u00e2n Thi\u00ean"},"description":"Ch\u00e0o c\u00e1c b\u1ea1n, m\u00ecnh l\u00e0 Xu\u00e2n Thi\u00ean. Trong k\u1ef7 nguy\u00ean s\u1ed1 thay \u0111\u1ed5i t\u1eebng gi\u1edd, m\u00ecnh \u1edf \u0111\u00e2y \u0111\u1ec3 c\u00f9ng b\u1ea1n c\u1eadp nh\u1eadt v\u00e0 ph\u00e2n t\u00edch nh\u1eefng chuy\u1ec3n \u0111\u1ed9ng m\u1edbi nh\u1ea5t c\u1ee7a th\u1ebf gi\u1edbi c\u00f4ng ngh\u1ec7. B\u1eb1ng s\u1ef1 am hi\u1ec3u v\u1ec1 h\u1ec7 sinh th\u00e1i c\u00e1c s\u1ea3n ph\u1ea9m c\u00f4ng ngh\u1ec7 hi\u1ec7n nay, m\u00ecnh cam k\u1ebft mang \u0111\u1ebfn cho b\u1ea1n nh\u1eefng g\u00f3c nh\u00ecn tr\u1ef1c quan, h\u1ed7 tr\u1ee3 b\u1ea1n l\u00e0m ch\u1ee7 c\u00f4ng ngh\u1ec7 m\u1ed9t c\u00e1ch th\u00f4ng minh nh\u1ea5t.","sameAs":["https:\/\/www.facebook.com\/hoanghamobilecom"],"url":"https:\/\/hoanghamobile.com\/tin-tuc\/author\/nguyen-xuan-thien\/"}]}},"_links":{"self":[{"href":"https:\/\/hoanghamobile.com\/tin-tuc\/wp-json\/wp\/v2\/posts\/280498","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/hoanghamobile.com\/tin-tuc\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/hoanghamobile.com\/tin-tuc\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/hoanghamobile.com\/tin-tuc\/wp-json\/wp\/v2\/users\/102"}],"replies":[{"embeddable":true,"href":"https:\/\/hoanghamobile.com\/tin-tuc\/wp-json\/wp\/v2\/comments?post=280498"}],"version-history":[{"count":0,"href":"https:\/\/hoanghamobile.com\/tin-tuc\/wp-json\/wp\/v2\/posts\/280498\/revisions"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/hoanghamobile.com\/tin-tuc\/wp-json\/wp\/v2\/media\/283078"}],"wp:attachment":[{"href":"https:\/\/hoanghamobile.com\/tin-tuc\/wp-json\/wp\/v2\/media?parent=280498"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/hoanghamobile.com\/tin-tuc\/wp-json\/wp\/v2\/categories?post=280498"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/hoanghamobile.com\/tin-tuc\/wp-json\/wp\/v2\/tags?post=280498"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}