{"id":41832,"date":"2022-04-12T13:39:32","date_gmt":"2022-04-12T06:39:32","guid":{"rendered":"https:\/\/divineshop.vn\/tin-tuc\/?p=41832"},"modified":"2022-04-12T13:39:32","modified_gmt":"2022-04-12T06:39:32","slug":"kham-pha-cach-tinh-so-ngay-trong-excel-cuc-de-chua-chac-ban-da-biet","status":"publish","type":"post","link":"https:\/\/divineshop.vn\/tin-tuc\/kham-pha-cach-tinh-so-ngay-trong-excel-cuc-de-chua-chac-ban-da-biet\/","title":{"rendered":"Kh\u00e1m ph\u00e1 c\u00e1ch t\u00ednh s\u1ed1 ng\u00e0y trong Excel c\u1ef1c d\u1ec5 ch\u01b0a ch\u1eafc b\u1ea1n \u0111\u00e3 bi\u1ebft"},"content":{"rendered":"<div class=\"content-inner\">\n<p><strong>B\u1ea1n th\u01b0\u1eddng xuy\u00ean s\u1eed d\u1ee5ng Excel \u0111\u1ec3 t\u00ednh to\u00e1n v\u00e0 tr\u00ecnh b\u00e0y s\u1ed1 li\u1ec7u. Tuy nhi\u00ean, b\u1ea1n c\u00f3 th\u1ec3 s\u1ebd g\u1eb7p kh\u00f3 kh\u0103n v\u1edbi nh\u1eefng h\u00e0m ch\u01b0a t\u1eebng s\u1eed d\u1ee5ng. B\u00e0i vi\u1ebft n\u00e0y Divine Shop s\u1ebd chia s\u1ebb cho b\u1ea1n c\u00e1ch t\u00ednh s\u1ed1 ng\u00e0y trong Excel m\u1ed9t c\u00e1ch chi ti\u1ebft nh\u1ea5t gi\u00fap b\u1ea1n s\u1eed d\u1ee5ng Excel thu\u1eadn ti\u1ec7n h\u01a1n.<\/strong><\/p>\n<p>Excel l\u00e0 m\u1ed9t ph\u1ea7n m\u1ec1m r\u1ea5t quen thu\u1ed9c \u0111\u1ed1i v\u1edbi nh\u00e2n vi\u00ean v\u0103n ph\u00f2ng. V\u00ec v\u1eady, \u0111\u1ec3 s\u1eed d\u1ee5ng Excel m\u1ed9t c\u00e1ch chuy\u00ean nghi\u1ec7p h\u01a1n, b\u1ea1n h\u00e3y l\u01b0u l\u1ea1i ngay m\u1eb9o t\u00ednh s\u1ed1 l\u01b0\u1ee3ng ng\u00e0y b\u1eb1ng Excel c\u1ef1c \u0111\u01a1n gi\u1ea3n n\u00e0y nh\u00e9!<\/p>\n<p><img loading=\"lazy\" class=\"aligncenter size-full wp-image-532882\" src=\"https:\/\/divineshop.vn\/tin-tuc\/wp-content\/uploads\/2022\/03\/kham-pha-cach-tinh-so-ngay-trong-excel-cuc-de-chua-chac-ban-da-biet_623d3cb9ac69f.jpeg\" alt=\"Kh\u00e1m ph\u00e1 c\u00e1ch t\u00ednh s\u1ed1 ng\u00e0y trong Excel c\u1ef1c d\u1ec5 ch\u01b0a ch\u1eafc b\u1ea1n \u0111\u00e3 bi\u1ebft\" width=\"1000\" height=\"563\" \/><\/p>\n<div id=\"ez-toc-container\" class=\"ez-toc-v2_0_17 counter-hierarchy counter-decimal ez-toc-grey\">\n<h2><span class=\"ez-toc-section\" id=\"Ham_tinh_so_ngay_trong_Excel_tu_ngay_hien_tai\"><\/span><span id=\"Ham_tinh_so_ngay_trong_Excel_tu_ngay_hien_tai\" class=\"ez-toc-section\"><\/span><strong><span style=\"font-size: 18pt\">H\u00e0m t\u00ednh s\u1ed1 ng\u00e0y trong Excel t\u1eeb ng\u00e0y hi\u1ec7n t\u1ea1i<\/span><\/strong><span class=\"ez-toc-section-end\"><\/span><\/h2>\n<p>C\u00e1ch \u0111\u1ea7u ti\u00ean \u0111\u1ec3 t\u00ednh s\u1ed1 ng\u00e0y trong Excel b\u1eaft \u0111\u1ea7u t\u1eeb ng\u00e0y hi\u1ec7n t\u1ea1i, b\u1ea1n c\u00f3 th\u1ec3 s\u1eed d\u1ee5ng h\u00e0m sau \u0111\u00e2y: <strong>=TODAY()-B6<\/strong>. V\u1edbi B6 l\u00e0 \u00f4 ch\u1ee9a ng\u00e0y m\u00e0 b\u1ea1n c\u1ea7n t\u00ednh t\u1eeb ng\u00e0y \u0111\u00f3 \u0111\u1ebfn hi\u1ec7n t\u1ea1i.<\/p>\n<p><img loading=\"lazy\" class=\"aligncenter size-full wp-image-532850\" src=\"https:\/\/divineshop.vn\/tin-tuc\/wp-content\/uploads\/2022\/03\/kham-pha-cach-tinh-so-ngay-trong-excel-cuc-de-chua-chac-ban-da-biet_623d3cba63c37.gif\" alt=\"H\u00e0m t\u00ednh s\u1ed1 ng\u00e0y trong Excel t\u1eeb ng\u00e0y hi\u1ec7n t\u1ea1i - h\u00ecnh 1\" width=\"1320\" height=\"1027\" \/><\/p>\n<p>C\u00e1ch th\u1ee9 hai, b\u1ea1n c\u00f3 th\u1ec3 s\u1eed d\u1ee5ng h\u00e0m: <strong>=DATE(2022,1,27)-B6<\/strong>. Trong \u0111\u00f3:<\/p>\n<ul>\n<li>H\u00e0m DATE(n\u0103m,th\u00e1ng,ng\u00e0y), b\u1ea1n nh\u1eadp ng\u00e0y hi\u1ec7n t\u1ea1i v\u00e0o h\u00e0m DATE.<\/li>\n<li>B6 l\u00e0 v\u1ecb tr\u00ed ng\u00e0y m\u00e0 b\u1ea1n c\u1ea7n t\u00ednh s\u1ed1 ng\u00e0y t\u1eeb ng\u00e0y \u0111\u00f3 \u0111\u1ebfn ng\u00e0y hi\u1ec7n t\u1ea1i.<\/li>\n<\/ul>\n<p><img loading=\"lazy\" class=\"aligncenter size-full wp-image-532852\" src=\"https:\/\/divineshop.vn\/tin-tuc\/wp-content\/uploads\/2022\/03\/kham-pha-cach-tinh-so-ngay-trong-excel-cuc-de-chua-chac-ban-da-biet_623d3cbc779a9.gif\" alt=\"H\u00e0m t\u00ednh s\u1ed1 ng\u00e0y trong Excel t\u1eeb ng\u00e0y hi\u1ec7n t\u1ea1i - h\u00ecnh 2\" width=\"1317\" height=\"1030\" \/><\/p>\n<h2><span class=\"ez-toc-section\" id=\"Cach_tinh_so_ngay_trong_Excel_bang_cach_cong_them_so_ngay_tuan_thang\"><\/span><span id=\"Cach_tinh_so_ngay_trong_Excel_bang_cach_cong_them_so_ngay_tuan_thang\" class=\"ez-toc-section\"><\/span><strong><span style=\"font-size: 18pt\">C\u00e1ch t\u00ednh s\u1ed1 ng\u00e0y trong Excel b\u1eb1ng c\u00e1ch c\u1ed9ng th\u00eam s\u1ed1 ng\u00e0y, tu\u1ea7n, th\u00e1ng<\/span><\/strong><span class=\"ez-toc-section-end\"><\/span><\/h2>\n<p><strong>B\u01b0\u1edbc 1:<\/strong> \u0110\u1ec3 t\u00ednh s\u1ed1 ng\u00e0y b\u1eb1ng c\u00e1ch c\u1ed9ng th\u00eam ng\u00e0y, b\u1ea1n s\u1eed d\u1ee5ng h\u00e0m: <strong>=DATE(2022,1,1)+12<\/strong>. Trong \u0111\u00f3:<\/p>\n<ul>\n<li>DATE(n\u0103m,th\u00e1ng,ng\u00e0y): b\u1ea1n nh\u1eadp ng\u00e0y c\u1ea7n t\u00ednh.<\/li>\n<li>12: l\u00e0 s\u1ed1 ng\u00e0y m\u00e0 b\u1ea1n mu\u1ed1n c\u1ed9ng th\u00eam.<\/li>\n<\/ul>\n<p><img loading=\"lazy\" class=\"aligncenter wp-image-532853 size-full\" src=\"https:\/\/divineshop.vn\/tin-tuc\/wp-content\/uploads\/2022\/03\/kham-pha-cach-tinh-so-ngay-trong-excel-cuc-de-chua-chac-ban-da-biet_623d3cbeb0ae1.gif\" alt=\"C\u00e1ch t\u00ednh s\u1ed1 ng\u00e0y trong Excel b\u1eb1ng c\u00e1ch c\u1ed9ng th\u00eam s\u1ed1 ng\u00e0y, tu\u1ea7n, th\u00e1ng - b\u01b0\u1edbc 1\" width=\"1296\" height=\"1030\" \/><\/p>\n<p><strong>B\u01b0\u1edbc 2:<\/strong> \u0110\u1ec3 t\u00ednh s\u1ed1 ng\u00e0y c\u1ed9ng th\u00eam theo tu\u1ea7n, b\u1ea1n s\u1eed d\u1ee5ng nh\u01b0 sau: <strong>=DATE(2022,1,1)+2*7<\/strong>. V\u1edbi c\u00f4ng th\u1ee9c n\u00e0y:<\/p>\n<ul>\n<li>DATE(2022,1,1) l\u00e0 b\u1ea1n mu\u1ed1n c\u1ed9ng th\u00eam ng\u00e0y b\u1eaft \u0111\u1ea7u t\u1eeb ng\u00e0y 1\/1\/2022.<\/li>\n<li>2*7: ngh\u0129a l\u00e0 b\u1ea1n c\u1ed9ng th\u00eam 2 tu\u1ea7n n\u1eefa. N\u1ebfu b\u1ea1n mu\u1ed1n c\u1ed9ng th\u00eam 5 tu\u1ea7n th\u00ec s\u1eed d\u1ee5ng 5*7.<\/li>\n<\/ul>\n<p><img loading=\"lazy\" class=\"aligncenter wp-image-532854 size-full\" src=\"https:\/\/divineshop.vn\/tin-tuc\/wp-content\/uploads\/2022\/03\/kham-pha-cach-tinh-so-ngay-trong-excel-cuc-de-chua-chac-ban-da-biet_623d3cc10527e.gif\" alt=\"C\u00e1ch t\u00ednh s\u1ed1 ng\u00e0y trong Excel b\u1eb1ng c\u00e1ch c\u1ed9ng th\u00eam s\u1ed1 ng\u00e0y, tu\u1ea7n, th\u00e1ng - b\u01b0\u1edbc 2\" width=\"1376\" height=\"1027\" \/><\/p>\n<p><strong>B\u01b0\u1edbc 3:<\/strong> S\u1eed d\u1ee5ng h\u00e0m: <strong>=DATE(2022,1+5,1)<\/strong> \u0111\u1ec3 t\u00ednh s\u1ed1 ng\u00e0y trong Excel b\u1eb1ng c\u00e1ch c\u1ed9ng th\u00eam theo th\u00e1ng. B\u1ea1n ch\u1ec9 c\u1ea7n nh\u1eadp <strong>\u201c+ s\u1ed1 th\u00e1ng c\u1ea7n c\u1ed9ng th\u00eam\u201d<\/strong> v\u00e0o ph\u00eda sau th\u00e1ng l\u00e0 \u0111\u00e3 t\u00ednh \u0111\u01b0\u1ee3c s\u1ed1 ng\u00e0y theo th\u00e1ng th\u00e0nh c\u00f4ng. \u1ede v\u00ed d\u1ee5 d\u01b0\u1edbi \u0111\u00e2y, ng\u00e0y c\u1ea7n t\u00ednh l\u00e0 1\/1\/2022 v\u00e0 s\u1ed1 th\u00e1ng c\u1ea7n c\u1ed9ng th\u00eam l\u00e0 5.<\/p>\n<p><img loading=\"lazy\" class=\"aligncenter wp-image-532856 size-full\" src=\"https:\/\/divineshop.vn\/tin-tuc\/wp-content\/uploads\/2022\/03\/kham-pha-cach-tinh-so-ngay-trong-excel-cuc-de-chua-chac-ban-da-biet_623d3cc41f976.gif\" alt=\"C\u00e1ch t\u00ednh s\u1ed1 ng\u00e0y trong Excel b\u1eb1ng c\u00e1ch c\u1ed9ng th\u00eam s\u1ed1 ng\u00e0y, tu\u1ea7n, th\u00e1ng - b\u01b0\u1edbc 3\" width=\"1297\" height=\"1030\" \/><\/p>\n<p><strong>B\u01b0\u1edbc 4:<\/strong> B\u1ea1n nh\u1eadp h\u00e0m: <strong>=DATE(2022+2,1,1)<\/strong> \u0111\u1ec3 c\u1ed9ng th\u00eam s\u1ed1 n\u0103m. Nh\u01b0 v\u00ed d\u1ee5 d\u01b0\u1edbi \u0111\u00e2y, ng\u00e0y c\u1ea7n t\u00ednh l\u00e0 1\/1\/2022 v\u00e0 s\u1ed1 n\u0103m c\u1ea7n c\u1ed9ng th\u00eam l\u00e0 2.<\/p>\n<p><img loading=\"lazy\" class=\"aligncenter wp-image-532858 size-full\" src=\"https:\/\/divineshop.vn\/tin-tuc\/wp-content\/uploads\/2022\/03\/kham-pha-cach-tinh-so-ngay-trong-excel-cuc-de-chua-chac-ban-da-biet_623d3cc632f28.gif\" alt=\"C\u00e1ch t\u00ednh s\u1ed1 ng\u00e0y trong Excel b\u1eb1ng c\u00e1ch c\u1ed9ng th\u00eam s\u1ed1 ng\u00e0y, tu\u1ea7n, th\u00e1ng - b\u01b0\u1edbc 4\" width=\"1377\" height=\"1030\" \/><\/p>\n<h2><span class=\"ez-toc-section\" id=\"Huong_dan_ham_tinh_so_ngay_bang_cach_tru_bot_so_ngay_tuan_thang\"><\/span><span id=\"Huong_dan_ham_tinh_so_ngay_bang_cach_tru_bot_so_ngay_tuan_thang\" class=\"ez-toc-section\"><\/span><strong><span style=\"font-size: 18pt\">H\u01b0\u1edbng d\u1eabn h\u00e0m t\u00ednh s\u1ed1 ng\u00e0y b\u1eb1ng c\u00e1ch tr\u1eeb b\u1edbt s\u1ed1 ng\u00e0y, tu\u1ea7n, th\u00e1ng<\/span><\/strong><span class=\"ez-toc-section-end\"><\/span><\/h2>\n<p><strong>B\u01b0\u1edbc 1:<\/strong> \u0110\u1ec3 t\u00ednh s\u1ed1 ng\u00e0y trong Excel b\u1eb1ng c\u00e1ch tr\u1eeb b\u1edbt s\u1ed1 ng\u00e0y, b\u1ea1n nh\u1eadp: <strong>=DATE(2022,1,1)-10<\/strong>. Ngh\u0129a l\u00e0 b\u1ea1n mu\u1ed1n t\u00ednh ng\u00e0y t\u1eeb 1\/1\/2022 tr\u1eeb \u0111i 10 ng\u00e0y, k\u1ebft qu\u1ea3 s\u1ebd ra ng\u00e0y 22\/12\/2021.<\/p>\n<p><img loading=\"lazy\" class=\"aligncenter wp-image-532859 size-full\" src=\"https:\/\/divineshop.vn\/tin-tuc\/wp-content\/uploads\/2022\/03\/kham-pha-cach-tinh-so-ngay-trong-excel-cuc-de-chua-chac-ban-da-biet_623d3cc84c623.gif\" alt=\"H\u01b0\u1edbng d\u1eabn h\u00e0m t\u00ednh s\u1ed1 ng\u00e0y b\u1eb1ng c\u00e1ch tr\u1eeb b\u1edbt s\u1ed1 ng\u00e0y, tu\u1ea7n, th\u00e1ng - b\u01b0\u1edbc 1\" width=\"1376\" height=\"1028\" \/><\/p>\n<p><strong>B\u01b0\u1edbc 2:<\/strong> B\u1ea1n s\u1eed d\u1ee5ng h\u00e0m: <strong>=DATE(2022,1,1)-2*7<\/strong> \u0111\u1ec3 tr\u1eeb b\u1edbt ng\u00e0y theo tu\u1ea7n. V\u00ed d\u1ee5 d\u01b0\u1edbi \u0111\u00e2y c\u00f3 ngh\u0129a l\u00e0 b\u1ea1n tr\u1eeb 2 tu\u1ea7n k\u1ec3 t\u1eeb ng\u00e0y 1\/1\/2022, k\u1ebft qu\u1ea3 Excel s\u1ebd cho ra ng\u00e0y 18\/12\/2021.<\/p>\n<p><img loading=\"lazy\" class=\"aligncenter size-full wp-image-532860\" src=\"https:\/\/divineshop.vn\/tin-tuc\/wp-content\/uploads\/2022\/03\/kham-pha-cach-tinh-so-ngay-trong-excel-cuc-de-chua-chac-ban-da-biet_623d3cca5cfd8.gif\" alt=\"H\u01b0\u1edbng d\u1eabn h\u00e0m t\u00ednh s\u1ed1 ng\u00e0y b\u1eb1ng c\u00e1ch tr\u1eeb b\u1edbt s\u1ed1 ng\u00e0y, tu\u1ea7n, th\u00e1ng - b\u01b0\u1edbc 2\" width=\"1377\" height=\"1028\" \/><\/p>\n<p><strong>B\u01b0\u1edbc 3:<\/strong> \u0110\u1ec3 t\u00ednh ng\u00e0y b\u1eb1ng c\u00e1ch tr\u1eeb b\u1edbt ng\u00e0y theo th\u00e1ng, b\u1ea1n s\u1eed d\u1ee5ng: <strong>=DATE(2022,1-12,1)<\/strong>. C\u00f4ng th\u1ee9c n\u00e0y c\u00f3 ngh\u0129a l\u00e0 b\u1ea1n tr\u1eeb b\u1edbt 12 th\u00e1ng k\u1ec3 t\u1eeb ng\u00e0y 1\/1\/2022.<\/p>\n<p><img loading=\"lazy\" class=\"aligncenter size-full wp-image-532861\" src=\"https:\/\/divineshop.vn\/tin-tuc\/wp-content\/uploads\/2022\/03\/kham-pha-cach-tinh-so-ngay-trong-excel-cuc-de-chua-chac-ban-da-biet_623d3ccc6289e.gif\" alt=\"H\u01b0\u1edbng d\u1eabn h\u00e0m t\u00ednh s\u1ed1 ng\u00e0y b\u1eb1ng c\u00e1ch tr\u1eeb b\u1edbt s\u1ed1 ng\u00e0y, tu\u1ea7n, th\u00e1ng - b\u01b0\u1edbc 3\" width=\"1376\" height=\"1027\" \/><\/p>\n<p><strong>B\u01b0\u1edbc 4:<\/strong> \u0110\u1ec3 tr\u1eeb b\u1edbt ng\u00e0y theo n\u0103m, b\u1ea1n nh\u1eadp h\u00e0m: <strong>=DATE(2022-3,1,1)<\/strong>. V\u00ed d\u1ee5 sau \u0111\u00e2y c\u00f3 ngh\u0129a l\u00e0 tr\u1eeb b\u1edbt 3 n\u0103m k\u1ec3 t\u1eeb ng\u00e0y 1\/1\/2022.<\/p>\n<p><img loading=\"lazy\" class=\"aligncenter size-full wp-image-532862\" src=\"https:\/\/divineshop.vn\/tin-tuc\/wp-content\/uploads\/2022\/03\/kham-pha-cach-tinh-so-ngay-trong-excel-cuc-de-chua-chac-ban-da-biet_623d3cce8c92f.gif\" alt=\"H\u01b0\u1edbng d\u1eabn h\u00e0m t\u00ednh s\u1ed1 ng\u00e0y b\u1eb1ng c\u00e1ch tr\u1eeb b\u1edbt s\u1ed1 ng\u00e0y, tu\u1ea7n, th\u00e1ng - b\u01b0\u1edbc 4\" width=\"1298\" height=\"1028\" \/><\/p>\n<h2><span class=\"ez-toc-section\" id=\"Cach_tinh_thoi_gian_tich_luy_giua_hai_ngay\"><\/span><span id=\"Cach_tinh_thoi_gian_tich_luy_giua_hai_ngay\" class=\"ez-toc-section\"><\/span><strong><span style=\"font-size: 18pt\">C\u00e1ch t\u00ednh th\u1eddi gian t\u00edch l\u0169y gi\u1eefa hai ng\u00e0y<\/span><\/strong><span class=\"ez-toc-section-end\"><\/span><\/h2>\n<p>\u0110\u1ec3 t\u00ednh th\u1eddi gian t\u00edch l\u0169y gi\u1eefa hai ng\u00e0y b\u1ea5t k\u1ef3, b\u1ea1n c\u00f3 th\u1ec3 s\u1eed d\u1ee5ng h\u00e0m nh\u01b0 sau: <strong>=DATEDIF(B6,C6,\u201dy\u201d)&amp;\u201d years, \u201d &amp;DATEDIF(B6,C6,\u201dym\u201d)&amp;\u201d months, \u201d &amp;DATEDIF(B6,C6,\u201dmd\u201d)&amp;\u201d days\u201d<\/strong>, v\u1edbi B6 l\u00e0 ng\u00e0y b\u1eaft \u0111\u1ea7u v\u00e0 C6 l\u00e0 ng\u00e0y k\u1ebft th\u00fac. K\u1ebft qu\u1ea3 s\u1ebd ra d\u1ea1ng n\u0103m, th\u00e1ng, ng\u00e0y nh\u01b0 h\u00ecnh d\u01b0\u1edbi \u0111\u00e2y.<\/p>\n<p><img loading=\"lazy\" class=\"aligncenter size-full wp-image-532864\" src=\"https:\/\/divineshop.vn\/tin-tuc\/wp-content\/uploads\/2022\/03\/kham-pha-cach-tinh-so-ngay-trong-excel-cuc-de-chua-chac-ban-da-biet_623d3cd0c246e.gif\" alt=\"C\u00e1ch t\u00ednh th\u1eddi gian t\u00edch l\u0169y gi\u1eefa hai ng\u00e0y\" width=\"1920\" height=\"1027\" \/><\/p>\n<h2><span class=\"ez-toc-section\" id=\"Ham_tinh_so_luong_ngay_giua_hai_khoang_thoi_gian\"><\/span><span id=\"Ham_tinh_so_luong_ngay_giua_hai_khoang_thoi_gian\" class=\"ez-toc-section\"><\/span><strong><span style=\"font-size: 18pt\">H\u00e0m t\u00ednh s\u1ed1 l\u01b0\u1ee3ng ng\u00e0y gi\u1eefa hai kho\u1ea3ng th\u1eddi gian<\/span><\/strong><span class=\"ez-toc-section-end\"><\/span><\/h2>\n<p>B\u1ea1n s\u1eed d\u1ee5ng h\u00e0m: <b>=DATEDIF(B6,C6,\u201dd\u201d) <\/b>\u0111\u1ec3 t\u00ednh s\u1ed1 l\u01b0\u1ee3ng ng\u00e0y trong Excel gi\u1eefa hai ng\u00e0y b\u1ea5t k\u1ef3. K\u1ebft qu\u1ea3 c\u1ee7a ph\u00e9p t\u00ednh n\u00e0y s\u1ebd cho ra s\u1ed1 l\u01b0\u1ee3ng ng\u00e0y c\u1ee5 th\u1ec3.<\/p>\n<p><img loading=\"lazy\" class=\"aligncenter size-full wp-image-532865\" src=\"https:\/\/divineshop.vn\/tin-tuc\/wp-content\/uploads\/2022\/03\/kham-pha-cach-tinh-so-ngay-trong-excel-cuc-de-chua-chac-ban-da-biet_623d3cd373136.gif\" alt=\"H\u00e0m t\u00ednh s\u1ed1 l\u01b0\u1ee3ng ng\u00e0y gi\u1eefa hai kho\u1ea3ng th\u1eddi gian\" width=\"1920\" height=\"1030\" \/><\/p>\n<h2><span class=\"ez-toc-section\" id=\"Tam_ket\"><\/span><span id=\"Tam_ket\" class=\"ez-toc-section\"><\/span><strong><span style=\"font-size: 18pt\">T\u1ea1m k\u1ebft<\/span><\/strong><span class=\"ez-toc-section-end\"><\/span><\/h2>\n<p>B\u00e0i vi\u1ebft n\u00e0y Divine Shop \u0111\u00e3 h\u01b0\u1edbng d\u1eabn cho b\u1ea1n c\u00e1ch t\u00ednh s\u1ed1 ng\u00e0y trong Excel c\u1ef1c \u0111\u01a1n gi\u1ea3n. Hy v\u1ecdng nh\u1eefng chia s\u1ebb n\u00e0y s\u1ebd gi\u00fap b\u1ea1n s\u1eed d\u1ee5ng Excel chuy\u00ean nghi\u1ec7p h\u01a1n. Ch\u00fac b\u1ea1n th\u00e0nh c\u00f4ng.<\/p>\n<p style=\"text-align: center\">\u00a0<\/p>\n<\/div>\n<\/div>\n\n\n<hr class=\"wp-block-separator\"\/>\n\n\n\n<figure class=\"wp-block-image size-full\"><a href=\"https:\/\/divineshop.vn\/search?q=youtube+premium\" target=\"_blank\" rel=\"noopener\"><img loading=\"lazy\" width=\"728\" height=\"240\" src=\"https:\/\/divineshop.vn\/tin-tuc\/wp-content\/uploads\/2025\/04\/Youtube-1.png\" alt=\"\" class=\"wp-image-276746\" srcset=\"https:\/\/divineshop.vn\/tin-tuc\/wp-content\/uploads\/2025\/04\/Youtube-1.png 728w, https:\/\/divineshop.vn\/tin-tuc\/wp-content\/uploads\/2025\/04\/Youtube-1-300x99.png 300w, https:\/\/divineshop.vn\/tin-tuc\/wp-content\/uploads\/2025\/04\/Youtube-1-150x49.png 150w, https:\/\/divineshop.vn\/tin-tuc\/wp-content\/uploads\/2025\/04\/Youtube-1-696x229.png 696w\" sizes=\"(max-width: 728px) 100vw, 728px\" \/><\/a><\/figure>\n\n\n\n<!--nextpage-->\n\n\n\n<div class=\"wp-container-69d28148dfd31 wp-block-group\"><div class=\"wp-block-group__inner-container\"><\/div><\/div>\n\n\n\n<hr class=\"wp-block-separator\"\/>\n\n\n\n<!--nextpage-->\n\n\n\n<figure class=\"wp-block-image size-full\"><a href=\"https:\/\/divineshop.vn\/search\/mobile-data?utm_source=tin-tuc\" target=\"_blank\" rel=\"noopener\"><img loading=\"lazy\" width=\"728\" height=\"240\" src=\"https:\/\/divineshop.vn\/tin-tuc\/wp-content\/uploads\/2022\/06\/Data-di-dong-1.png\" alt=\"\" class=\"wp-image-91837\" srcset=\"https:\/\/divineshop.vn\/tin-tuc\/wp-content\/uploads\/2022\/06\/Data-di-dong-1.png 728w, https:\/\/divineshop.vn\/tin-tuc\/wp-content\/uploads\/2022\/06\/Data-di-dong-1-300x99.png 300w, https:\/\/divineshop.vn\/tin-tuc\/wp-content\/uploads\/2022\/06\/Data-di-dong-1-150x49.png 150w, https:\/\/divineshop.vn\/tin-tuc\/wp-content\/uploads\/2022\/06\/Data-di-dong-1-696x229.png 696w\" sizes=\"(max-width: 728px) 100vw, 728px\" \/><\/a><\/figure>\n\n\n\n<div class=\"wp-container-69d28148e030a wp-block-group\"><div class=\"wp-block-group__inner-container\"><\/div><\/div>\n","protected":false},"excerpt":{"rendered":"<p>B\u1ea1n th\u01b0\u1eddng xuy\u00ean s\u1eed d\u1ee5ng Excel \u0111\u1ec3 t\u00ednh to\u00e1n v\u00e0 tr\u00ecnh b\u00e0y s\u1ed1 li\u1ec7u. Tuy nhi\u00ean, b\u1ea1n c\u00f3 th\u1ec3 s\u1ebd g\u1eb7p kh\u00f3 kh\u0103n v\u1edbi nh\u1eefng h\u00e0m ch\u01b0a t\u1eebng s\u1eed d\u1ee5ng. B\u00e0i vi\u1ebft n\u00e0y Divine Shop s\u1ebd chia s\u1ebb cho b\u1ea1n c\u00e1ch t\u00ednh s\u1ed1 ng\u00e0y trong Excel m\u1ed9t c\u00e1ch chi ti\u1ebft nh\u1ea5t gi\u00fap b\u1ea1n s\u1eed d\u1ee5ng [&hellip;]<\/p>\n","protected":false},"author":12,"featured_media":41833,"comment_status":"closed","ping_status":"closed","sticky":false,"template":"","format":"standard","meta":{"inline_featured_image":false},"categories":[148],"tags":[255],"yoast_head":"<!-- This site is optimized with the Yoast SEO Premium plugin v18.1 (Yoast SEO v18.2) - https:\/\/yoast.com\/wordpress\/plugins\/seo\/ -->\n<meta name=\"description\" content=\"B\u1ea1n th\u01b0\u1eddng xuy\u00ean s\u1eed d\u1ee5ng Excel \u0111\u1ec3 t\u00ednh to\u00e1n v\u00e0 tr\u00ecnh b\u00e0y s\u1ed1 li\u1ec7u. Tuy nhi\u00ean, b\u1ea1n c\u00f3 th\u1ec3 s\u1ebd g\u1eb7p kh\u00f3 kh\u0103n v\u1edbi nh\u1eefng h\u00e0m ch\u01b0a t\u1eebng s\u1eed d\u1ee5ng. B\u00e0i vi\u1ebft n\u00e0y\" \/>\n<meta name=\"robots\" content=\"index, follow, max-snippet:-1, max-image-preview:large, max-video-preview:-1\" \/>\n<link rel=\"canonical\" href=\"https:\/\/divineshop.vn\/tin-tuc\/kham-pha-cach-tinh-so-ngay-trong-excel-cuc-de-chua-chac-ban-da-biet\/\" \/>\n<meta property=\"og:locale\" content=\"vi_VN\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"Kh\u00e1m ph\u00e1 c\u00e1ch t\u00ednh s\u1ed1 ng\u00e0y trong Excel c\u1ef1c d\u1ec5 ch\u01b0a ch\u1eafc b\u1ea1n \u0111\u00e3 bi\u1ebft\" \/>\n<meta property=\"og:description\" content=\"B\u1ea1n th\u01b0\u1eddng xuy\u00ean s\u1eed d\u1ee5ng Excel \u0111\u1ec3 t\u00ednh to\u00e1n v\u00e0 tr\u00ecnh b\u00e0y s\u1ed1 li\u1ec7u. Tuy nhi\u00ean, b\u1ea1n c\u00f3 th\u1ec3 s\u1ebd g\u1eb7p kh\u00f3 kh\u0103n v\u1edbi nh\u1eefng h\u00e0m ch\u01b0a t\u1eebng s\u1eed d\u1ee5ng. B\u00e0i vi\u1ebft n\u00e0y\" \/>\n<meta property=\"og:url\" content=\"https:\/\/divineshop.vn\/tin-tuc\/kham-pha-cach-tinh-so-ngay-trong-excel-cuc-de-chua-chac-ban-da-biet\/\" \/>\n<meta property=\"og:site_name\" content=\"Divine News\" \/>\n<meta property=\"article:publisher\" content=\"https:\/\/www.facebook.com\/divineshop.vn\" \/>\n<meta property=\"article:published_time\" content=\"2022-04-12T06:39:32+00:00\" \/>\n<meta property=\"og:image\" content=\"https:\/\/divineshop.vn\/tin-tuc\/wp-content\/uploads\/2022\/03\/kham-pha-cach-tinh-so-ngay-trong-excel-cuc-de-chua-chac-ban-da-biet_623d3cb914794.jpeg\" \/>\n\t<meta property=\"og:image:width\" content=\"1000\" \/>\n\t<meta property=\"og:image:height\" content=\"563\" \/>\n\t<meta property=\"og:image:type\" content=\"image\/jpeg\" \/>\n<meta name=\"twitter:card\" content=\"summary_large_image\" \/>\n<meta name=\"twitter:label1\" content=\"Written by\" \/>\n\t<meta name=\"twitter:data1\" content=\"CTV\" \/>\n\t<meta name=\"twitter:label2\" content=\"Est. reading time\" \/>\n\t<meta name=\"twitter:data2\" content=\"7 ph\u00fat\" \/>\n<script type=\"application\/ld+json\" class=\"yoast-schema-graph\">{\"@context\":\"https:\/\/schema.org\",\"@graph\":[{\"@type\":\"Organization\",\"@id\":\"https:\/\/divineshop.vn\/tin-tuc\/#organization\",\"name\":\"Divine News\",\"url\":\"https:\/\/divineshop.vn\/tin-tuc\/\",\"sameAs\":[\"https:\/\/www.facebook.com\/divineshop.vn\",\"https:\/\/www.instagram.com\/divineshop.game\/\",\"https:\/\/www.youtube.com\/DivineTVN\"],\"logo\":{\"@type\":\"ImageObject\",\"@id\":\"https:\/\/divineshop.vn\/tin-tuc\/#logo\",\"inLanguage\":\"vi\",\"url\":\"https:\/\/divineshop.vn\/tin-tuc\/wp-content\/uploads\/2022\/03\/Avatar.jpg\",\"contentUrl\":\"https:\/\/divineshop.vn\/tin-tuc\/wp-content\/uploads\/2022\/03\/Avatar.jpg\",\"width\":960,\"height\":960,\"caption\":\"Divine News\"},\"image\":{\"@id\":\"https:\/\/divineshop.vn\/tin-tuc\/#logo\"}},{\"@type\":\"WebSite\",\"@id\":\"https:\/\/divineshop.vn\/tin-tuc\/#website\",\"url\":\"https:\/\/divineshop.vn\/tin-tuc\/\",\"name\":\"Divine News\",\"description\":\"Tin hay m\u1ed7i ng\u00e0y\",\"publisher\":{\"@id\":\"https:\/\/divineshop.vn\/tin-tuc\/#organization\"},\"potentialAction\":[{\"@type\":\"SearchAction\",\"target\":{\"@type\":\"EntryPoint\",\"urlTemplate\":\"https:\/\/divineshop.vn\/tin-tuc\/?s={search_term_string}\"},\"query-input\":\"required name=search_term_string\"}],\"inLanguage\":\"vi\"},{\"@type\":\"ImageObject\",\"@id\":\"https:\/\/divineshop.vn\/tin-tuc\/kham-pha-cach-tinh-so-ngay-trong-excel-cuc-de-chua-chac-ban-da-biet\/#primaryimage\",\"inLanguage\":\"vi\",\"url\":\"https:\/\/divineshop.vn\/tin-tuc\/wp-content\/uploads\/2022\/03\/kham-pha-cach-tinh-so-ngay-trong-excel-cuc-de-chua-chac-ban-da-biet_623d3cb914794.jpeg\",\"contentUrl\":\"https:\/\/divineshop.vn\/tin-tuc\/wp-content\/uploads\/2022\/03\/kham-pha-cach-tinh-so-ngay-trong-excel-cuc-de-chua-chac-ban-da-biet_623d3cb914794.jpeg\",\"width\":1000,\"height\":563},{\"@type\":\"WebPage\",\"@id\":\"https:\/\/divineshop.vn\/tin-tuc\/kham-pha-cach-tinh-so-ngay-trong-excel-cuc-de-chua-chac-ban-da-biet\/#webpage\",\"url\":\"https:\/\/divineshop.vn\/tin-tuc\/kham-pha-cach-tinh-so-ngay-trong-excel-cuc-de-chua-chac-ban-da-biet\/\",\"name\":\"Kh\u00e1m ph\u00e1 c\u00e1ch t\u00ednh s\u1ed1 ng\u00e0y trong Excel c\u1ef1c d\u1ec5 ch\u01b0a ch\u1eafc b\u1ea1n \u0111\u00e3 bi\u1ebft - Divine News\",\"isPartOf\":{\"@id\":\"https:\/\/divineshop.vn\/tin-tuc\/#website\"},\"primaryImageOfPage\":{\"@id\":\"https:\/\/divineshop.vn\/tin-tuc\/kham-pha-cach-tinh-so-ngay-trong-excel-cuc-de-chua-chac-ban-da-biet\/#primaryimage\"},\"datePublished\":\"2022-04-12T06:39:32+00:00\",\"dateModified\":\"2022-04-12T06:39:32+00:00\",\"description\":\"B\u1ea1n th\u01b0\u1eddng xuy\u00ean s\u1eed d\u1ee5ng Excel \u0111\u1ec3 t\u00ednh to\u00e1n v\u00e0 tr\u00ecnh b\u00e0y s\u1ed1 li\u1ec7u. Tuy nhi\u00ean, b\u1ea1n c\u00f3 th\u1ec3 s\u1ebd g\u1eb7p kh\u00f3 kh\u0103n v\u1edbi nh\u1eefng h\u00e0m ch\u01b0a t\u1eebng s\u1eed d\u1ee5ng. B\u00e0i vi\u1ebft n\u00e0y\",\"breadcrumb\":{\"@id\":\"https:\/\/divineshop.vn\/tin-tuc\/kham-pha-cach-tinh-so-ngay-trong-excel-cuc-de-chua-chac-ban-da-biet\/#breadcrumb\"},\"inLanguage\":\"vi\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/divineshop.vn\/tin-tuc\/kham-pha-cach-tinh-so-ngay-trong-excel-cuc-de-chua-chac-ban-da-biet\/\"]}]},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/divineshop.vn\/tin-tuc\/kham-pha-cach-tinh-so-ngay-trong-excel-cuc-de-chua-chac-ban-da-biet\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Home\",\"item\":\"https:\/\/divineshop.vn\/tin-tuc\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"Kh\u00e1m ph\u00e1 c\u00e1ch t\u00ednh s\u1ed1 ng\u00e0y trong Excel c\u1ef1c d\u1ec5 ch\u01b0a ch\u1eafc b\u1ea1n \u0111\u00e3 bi\u1ebft\"}]},{\"@type\":\"Article\",\"@id\":\"https:\/\/divineshop.vn\/tin-tuc\/kham-pha-cach-tinh-so-ngay-trong-excel-cuc-de-chua-chac-ban-da-biet\/#article\",\"isPartOf\":{\"@id\":\"https:\/\/divineshop.vn\/tin-tuc\/kham-pha-cach-tinh-so-ngay-trong-excel-cuc-de-chua-chac-ban-da-biet\/#webpage\"},\"author\":{\"@id\":\"https:\/\/divineshop.vn\/tin-tuc\/#\/schema\/person\/ab675a5edaf3a6c9f037d16aa192413a\"},\"headline\":\"Kh\u00e1m ph\u00e1 c\u00e1ch t\u00ednh s\u1ed1 ng\u00e0y trong Excel c\u1ef1c d\u1ec5 ch\u01b0a ch\u1eafc b\u1ea1n \u0111\u00e3 bi\u1ebft\",\"datePublished\":\"2022-04-12T06:39:32+00:00\",\"dateModified\":\"2022-04-12T06:39:32+00:00\",\"mainEntityOfPage\":{\"@id\":\"https:\/\/divineshop.vn\/tin-tuc\/kham-pha-cach-tinh-so-ngay-trong-excel-cuc-de-chua-chac-ban-da-biet\/#webpage\"},\"wordCount\":1042,\"publisher\":{\"@id\":\"https:\/\/divineshop.vn\/tin-tuc\/#organization\"},\"image\":{\"@id\":\"https:\/\/divineshop.vn\/tin-tuc\/kham-pha-cach-tinh-so-ngay-trong-excel-cuc-de-chua-chac-ban-da-biet\/#primaryimage\"},\"thumbnailUrl\":\"https:\/\/divineshop.vn\/tin-tuc\/wp-content\/uploads\/2022\/03\/kham-pha-cach-tinh-so-ngay-trong-excel-cuc-de-chua-chac-ban-da-biet_623d3cb914794.jpeg\",\"keywords\":[\"Th\u1ee7 thu\u1eadt Excel\"],\"articleSection\":[\"M\u1eb8O HAY\"],\"inLanguage\":\"vi\",\"copyrightYear\":\"2022\",\"copyrightHolder\":{\"@id\":\"https:\/\/divineshop.vn\/tin-tuc\/#organization\"}},{\"@type\":\"Person\",\"@id\":\"https:\/\/divineshop.vn\/tin-tuc\/#\/schema\/person\/ab675a5edaf3a6c9f037d16aa192413a\",\"name\":\"CTV\",\"image\":{\"@type\":\"ImageObject\",\"@id\":\"https:\/\/divineshop.vn\/tin-tuc\/#personlogo\",\"inLanguage\":\"vi\",\"url\":\"https:\/\/secure.gravatar.com\/avatar\/99e99dbd029810d7d24fba0cc828c79b?s=96&d=mm&r=g\",\"contentUrl\":\"https:\/\/secure.gravatar.com\/avatar\/99e99dbd029810d7d24fba0cc828c79b?s=96&d=mm&r=g\",\"caption\":\"CTV\"}}]}<\/script>\n<!-- \/ Yoast SEO Premium plugin. -->","yoast_head_json":{"description":"B\u1ea1n th\u01b0\u1eddng xuy\u00ean s\u1eed d\u1ee5ng Excel \u0111\u1ec3 t\u00ednh to\u00e1n v\u00e0 tr\u00ecnh b\u00e0y s\u1ed1 li\u1ec7u. Tuy nhi\u00ean, b\u1ea1n c\u00f3 th\u1ec3 s\u1ebd g\u1eb7p kh\u00f3 kh\u0103n v\u1edbi nh\u1eefng h\u00e0m ch\u01b0a t\u1eebng s\u1eed d\u1ee5ng. B\u00e0i vi\u1ebft n\u00e0y","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:\/\/divineshop.vn\/tin-tuc\/kham-pha-cach-tinh-so-ngay-trong-excel-cuc-de-chua-chac-ban-da-biet\/","og_locale":"vi_VN","og_type":"article","og_title":"Kh\u00e1m ph\u00e1 c\u00e1ch t\u00ednh s\u1ed1 ng\u00e0y trong Excel c\u1ef1c d\u1ec5 ch\u01b0a ch\u1eafc b\u1ea1n \u0111\u00e3 bi\u1ebft","og_description":"B\u1ea1n th\u01b0\u1eddng xuy\u00ean s\u1eed d\u1ee5ng Excel \u0111\u1ec3 t\u00ednh to\u00e1n v\u00e0 tr\u00ecnh b\u00e0y s\u1ed1 li\u1ec7u. Tuy nhi\u00ean, b\u1ea1n c\u00f3 th\u1ec3 s\u1ebd g\u1eb7p kh\u00f3 kh\u0103n v\u1edbi nh\u1eefng h\u00e0m ch\u01b0a t\u1eebng s\u1eed d\u1ee5ng. B\u00e0i vi\u1ebft n\u00e0y","og_url":"https:\/\/divineshop.vn\/tin-tuc\/kham-pha-cach-tinh-so-ngay-trong-excel-cuc-de-chua-chac-ban-da-biet\/","og_site_name":"Divine News","article_publisher":"https:\/\/www.facebook.com\/divineshop.vn","article_published_time":"2022-04-12T06:39:32+00:00","og_image":[{"width":1000,"height":563,"url":"https:\/\/divineshop.vn\/tin-tuc\/wp-content\/uploads\/2022\/03\/kham-pha-cach-tinh-so-ngay-trong-excel-cuc-de-chua-chac-ban-da-biet_623d3cb914794.jpeg","type":"image\/jpeg"}],"twitter_card":"summary_large_image","twitter_misc":{"Written by":"CTV","Est. reading time":"7 ph\u00fat"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"Organization","@id":"https:\/\/divineshop.vn\/tin-tuc\/#organization","name":"Divine News","url":"https:\/\/divineshop.vn\/tin-tuc\/","sameAs":["https:\/\/www.facebook.com\/divineshop.vn","https:\/\/www.instagram.com\/divineshop.game\/","https:\/\/www.youtube.com\/DivineTVN"],"logo":{"@type":"ImageObject","@id":"https:\/\/divineshop.vn\/tin-tuc\/#logo","inLanguage":"vi","url":"https:\/\/divineshop.vn\/tin-tuc\/wp-content\/uploads\/2022\/03\/Avatar.jpg","contentUrl":"https:\/\/divineshop.vn\/tin-tuc\/wp-content\/uploads\/2022\/03\/Avatar.jpg","width":960,"height":960,"caption":"Divine News"},"image":{"@id":"https:\/\/divineshop.vn\/tin-tuc\/#logo"}},{"@type":"WebSite","@id":"https:\/\/divineshop.vn\/tin-tuc\/#website","url":"https:\/\/divineshop.vn\/tin-tuc\/","name":"Divine News","description":"Tin hay m\u1ed7i ng\u00e0y","publisher":{"@id":"https:\/\/divineshop.vn\/tin-tuc\/#organization"},"potentialAction":[{"@type":"SearchAction","target":{"@type":"EntryPoint","urlTemplate":"https:\/\/divineshop.vn\/tin-tuc\/?s={search_term_string}"},"query-input":"required name=search_term_string"}],"inLanguage":"vi"},{"@type":"ImageObject","@id":"https:\/\/divineshop.vn\/tin-tuc\/kham-pha-cach-tinh-so-ngay-trong-excel-cuc-de-chua-chac-ban-da-biet\/#primaryimage","inLanguage":"vi","url":"https:\/\/divineshop.vn\/tin-tuc\/wp-content\/uploads\/2022\/03\/kham-pha-cach-tinh-so-ngay-trong-excel-cuc-de-chua-chac-ban-da-biet_623d3cb914794.jpeg","contentUrl":"https:\/\/divineshop.vn\/tin-tuc\/wp-content\/uploads\/2022\/03\/kham-pha-cach-tinh-so-ngay-trong-excel-cuc-de-chua-chac-ban-da-biet_623d3cb914794.jpeg","width":1000,"height":563},{"@type":"WebPage","@id":"https:\/\/divineshop.vn\/tin-tuc\/kham-pha-cach-tinh-so-ngay-trong-excel-cuc-de-chua-chac-ban-da-biet\/#webpage","url":"https:\/\/divineshop.vn\/tin-tuc\/kham-pha-cach-tinh-so-ngay-trong-excel-cuc-de-chua-chac-ban-da-biet\/","name":"Kh\u00e1m ph\u00e1 c\u00e1ch t\u00ednh s\u1ed1 ng\u00e0y trong Excel c\u1ef1c d\u1ec5 ch\u01b0a ch\u1eafc b\u1ea1n \u0111\u00e3 bi\u1ebft - Divine News","isPartOf":{"@id":"https:\/\/divineshop.vn\/tin-tuc\/#website"},"primaryImageOfPage":{"@id":"https:\/\/divineshop.vn\/tin-tuc\/kham-pha-cach-tinh-so-ngay-trong-excel-cuc-de-chua-chac-ban-da-biet\/#primaryimage"},"datePublished":"2022-04-12T06:39:32+00:00","dateModified":"2022-04-12T06:39:32+00:00","description":"B\u1ea1n th\u01b0\u1eddng xuy\u00ean s\u1eed d\u1ee5ng Excel \u0111\u1ec3 t\u00ednh to\u00e1n v\u00e0 tr\u00ecnh b\u00e0y s\u1ed1 li\u1ec7u. Tuy nhi\u00ean, b\u1ea1n c\u00f3 th\u1ec3 s\u1ebd g\u1eb7p kh\u00f3 kh\u0103n v\u1edbi nh\u1eefng h\u00e0m ch\u01b0a t\u1eebng s\u1eed d\u1ee5ng. B\u00e0i vi\u1ebft n\u00e0y","breadcrumb":{"@id":"https:\/\/divineshop.vn\/tin-tuc\/kham-pha-cach-tinh-so-ngay-trong-excel-cuc-de-chua-chac-ban-da-biet\/#breadcrumb"},"inLanguage":"vi","potentialAction":[{"@type":"ReadAction","target":["https:\/\/divineshop.vn\/tin-tuc\/kham-pha-cach-tinh-so-ngay-trong-excel-cuc-de-chua-chac-ban-da-biet\/"]}]},{"@type":"BreadcrumbList","@id":"https:\/\/divineshop.vn\/tin-tuc\/kham-pha-cach-tinh-so-ngay-trong-excel-cuc-de-chua-chac-ban-da-biet\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Home","item":"https:\/\/divineshop.vn\/tin-tuc\/"},{"@type":"ListItem","position":2,"name":"Kh\u00e1m ph\u00e1 c\u00e1ch t\u00ednh s\u1ed1 ng\u00e0y trong Excel c\u1ef1c d\u1ec5 ch\u01b0a ch\u1eafc b\u1ea1n \u0111\u00e3 bi\u1ebft"}]},{"@type":"Article","@id":"https:\/\/divineshop.vn\/tin-tuc\/kham-pha-cach-tinh-so-ngay-trong-excel-cuc-de-chua-chac-ban-da-biet\/#article","isPartOf":{"@id":"https:\/\/divineshop.vn\/tin-tuc\/kham-pha-cach-tinh-so-ngay-trong-excel-cuc-de-chua-chac-ban-da-biet\/#webpage"},"author":{"@id":"https:\/\/divineshop.vn\/tin-tuc\/#\/schema\/person\/ab675a5edaf3a6c9f037d16aa192413a"},"headline":"Kh\u00e1m ph\u00e1 c\u00e1ch t\u00ednh s\u1ed1 ng\u00e0y trong Excel c\u1ef1c d\u1ec5 ch\u01b0a ch\u1eafc b\u1ea1n \u0111\u00e3 bi\u1ebft","datePublished":"2022-04-12T06:39:32+00:00","dateModified":"2022-04-12T06:39:32+00:00","mainEntityOfPage":{"@id":"https:\/\/divineshop.vn\/tin-tuc\/kham-pha-cach-tinh-so-ngay-trong-excel-cuc-de-chua-chac-ban-da-biet\/#webpage"},"wordCount":1042,"publisher":{"@id":"https:\/\/divineshop.vn\/tin-tuc\/#organization"},"image":{"@id":"https:\/\/divineshop.vn\/tin-tuc\/kham-pha-cach-tinh-so-ngay-trong-excel-cuc-de-chua-chac-ban-da-biet\/#primaryimage"},"thumbnailUrl":"https:\/\/divineshop.vn\/tin-tuc\/wp-content\/uploads\/2022\/03\/kham-pha-cach-tinh-so-ngay-trong-excel-cuc-de-chua-chac-ban-da-biet_623d3cb914794.jpeg","keywords":["Th\u1ee7 thu\u1eadt Excel"],"articleSection":["M\u1eb8O HAY"],"inLanguage":"vi","copyrightYear":"2022","copyrightHolder":{"@id":"https:\/\/divineshop.vn\/tin-tuc\/#organization"}},{"@type":"Person","@id":"https:\/\/divineshop.vn\/tin-tuc\/#\/schema\/person\/ab675a5edaf3a6c9f037d16aa192413a","name":"CTV","image":{"@type":"ImageObject","@id":"https:\/\/divineshop.vn\/tin-tuc\/#personlogo","inLanguage":"vi","url":"https:\/\/secure.gravatar.com\/avatar\/99e99dbd029810d7d24fba0cc828c79b?s=96&d=mm&r=g","contentUrl":"https:\/\/secure.gravatar.com\/avatar\/99e99dbd029810d7d24fba0cc828c79b?s=96&d=mm&r=g","caption":"CTV"}}]}},"_links":{"self":[{"href":"https:\/\/divineshop.vn\/tin-tuc\/wp-json\/wp\/v2\/posts\/41832"}],"collection":[{"href":"https:\/\/divineshop.vn\/tin-tuc\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/divineshop.vn\/tin-tuc\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/divineshop.vn\/tin-tuc\/wp-json\/wp\/v2\/users\/12"}],"replies":[{"embeddable":true,"href":"https:\/\/divineshop.vn\/tin-tuc\/wp-json\/wp\/v2\/comments?post=41832"}],"version-history":[{"count":2,"href":"https:\/\/divineshop.vn\/tin-tuc\/wp-json\/wp\/v2\/posts\/41832\/revisions"}],"predecessor-version":[{"id":71853,"href":"https:\/\/divineshop.vn\/tin-tuc\/wp-json\/wp\/v2\/posts\/41832\/revisions\/71853"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/divineshop.vn\/tin-tuc\/wp-json\/wp\/v2\/media\/41833"}],"wp:attachment":[{"href":"https:\/\/divineshop.vn\/tin-tuc\/wp-json\/wp\/v2\/media?parent=41832"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/divineshop.vn\/tin-tuc\/wp-json\/wp\/v2\/categories?post=41832"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/divineshop.vn\/tin-tuc\/wp-json\/wp\/v2\/tags?post=41832"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}