{"id":4963,"date":"2025-11-20T15:42:25","date_gmt":"2025-11-20T08:42:25","guid":{"rendered":"https:\/\/autofillform.com\/blog\/cach-su-dung-ham-year-trong-excel-chi-tiet-de-hieu\/"},"modified":"2025-11-20T15:42:25","modified_gmt":"2025-11-20T08:42:25","slug":"cach-su-dung-ham-year-trong-excel-chi-tiet-de-hieu","status":"publish","type":"post","link":"https:\/\/autofillform.com\/blog\/cach-su-dung-ham-year-trong-excel-chi-tiet-de-hieu\/","title":{"rendered":"C\u00e1ch s\u1eed d\u1ee5ng h\u00e0m YEAR trong Excel chi ti\u1ebft, d\u1ec5 hi\u1ec3u"},"content":{"rendered":"
\n
\u00a0<\/div>\n

Khi l\u00e0m vi\u1ec7c v\u1edbi d\u1eef li\u1ec7u theo th\u1eddi gian, vi\u1ec7c l\u1ea5y nhanh ph\u1ea7n n\u0103m t\u1eeb m\u1ed9t ng\u00e0y c\u1ee5 th\u1ec3 gi\u00fap b\u1ea1n x\u1eed l\u00fd v\u00e0 t\u1ed5ng h\u1ee3p th\u00f4ng tin ch\u00ednh x\u00e1c h\u01a1n. Trong b\u00e0i vi\u1ebft n\u00e0y, b\u1ea1n s\u1ebd \u0111\u01b0\u1ee3c h\u01b0\u1edbng d\u1eabn c\u00e1ch d\u00f9ng h\u00e0m YEAR trong Excel, c\u00f9ng c\u00e1c v\u00ed d\u1ee5 minh h\u1ecda gi\u00fap b\u1ea1n n\u1eafm r\u00f5 v\u00e0 \u00e1p d\u1ee5ng ngay v\u00e0o b\u1ea3ng t\u00ednh c\u1ee7a m\u00ecnh.<\/p>\n

\"H\u00e0mH\u01b0\u1edbng d\u1eabn chi ti\u1ebft c\u00e1ch s\u1eed d\u1ee5ng h\u00e0m YEAR trong Excel<\/em><\/p>\n

\n

1. C\u00fa ph\u00e1p c\u1ee7a h\u00e0m YEAR<\/h2>\n<\/div>\n

H\u00e0m YEAR \u0111\u01b0\u1ee3c d\u00f9ng \u0111\u1ec3 t\u00e1ch ph\u1ea7n n\u0103m t\u1eeb m\u1ed9t gi\u00e1 tr\u1ecb ng\u00e0y th\u00e1ng trong Excel. K\u1ebft qu\u1ea3 tr\u1ea3 v\u1ec1 l\u00e0 m\u1ed9t s\u1ed1 nguy\u00ean n\u1eb1m trong kho\u1ea3ng t\u1eeb 1900 \u0111\u1ebfn 9999.<\/p>\n

C\u00fa ph\u00e1p:<\/strong> =YEAR(serial_number)<\/p>\n

Gi\u1ea3i th\u00edch tham s\u1ed1:<\/strong><\/p>\n

    \n
  • serial_number: <\/strong>Gi\u00e1 tr\u1ecb ng\u00e0y m\u00e0 b\u1ea1n mu\u1ed1n l\u1ea5y n\u0103m.<\/li>\n<\/ul>\n

    L\u01b0u \u00fd:<\/strong><\/p>\n

      \n
    • N\u00ean nh\u1eadp serial_number b\u1eb1ng h\u00e0m DATE, b\u1eb1ng s\u1ed1 seri ng\u00e0y, ho\u1eb7c tham chi\u1ebfu m\u1ed9t \u00f4 ch\u1ee9a ng\u00e0y h\u1ee3p l\u1ec7 \u0111\u1ec3 h\u1ea1n ch\u1ebf l\u1ed7i.<\/li>\n
    • Excel qu\u1ea3n l\u00fd ng\u00e0y th\u00e1ng b\u1eb1ng s\u1ed1 seri li\u00ean t\u1ee5c, trong \u0111\u00f3 1\/1\/1900 t\u01b0\u01a1ng \u1ee9ng v\u1edbi s\u1ed1 1 v\u00e0 t\u0103ng d\u1ea7n theo t\u1eebng ng\u00e0y.<\/li>\n<\/ul>\n
      \n

      2. V\u00ed d\u1ee5 c\u01a1 b\u1ea3n v\u1ec1 h\u00e0m YEAR<\/h2>\n<\/div>\n

      V\u00ed d\u1ee5 1: T\u00e1ch n\u0103m t\u1eeb ng\u00e0y th\u00e1ng b\u1eb1ng h\u00e0m YEAR<\/strong><\/p>\n

      Gi\u1ea3 s\u1eed b\u1ea1n c\u00f3 m\u1ed9t c\u1ed9t ch\u1ee9a d\u1eef li\u1ec7u ng\u00e0y th\u00e1ng v\u00e0 mu\u1ed1n t\u00e1ch ri\u00eang ph\u1ea7n n\u0103m sang c\u1ed9t b\u00ean c\u1ea1nh, nh\u01b0 minh h\u1ecda d\u01b0\u1edbi \u0111\u00e2y.<\/p>\n

      B\u01b0\u1edbc 1:<\/strong> T\u1ea1i \u00f4 c\u1ea7n hi\u1ec3n th\u1ecb k\u1ebft qu\u1ea3, nh\u1eadp c\u00f4ng th\u1ee9c: =YEAR(A2)<\/p>\n

      L\u01b0u \u00fd: <\/strong>H\u00e3y ki\u1ec3m tra \u0111\u1ecbnh d\u1ea1ng c\u1ee7a \u00f4 d\u1eef li\u1ec7u g\u1ed1c. N\u1ebfu gi\u00e1 tr\u1ecb ng\u00e0y th\u00e1ng \u0111ang \u1edf d\u1ea1ng Text, b\u1ea1n c\u1ea7n chuy\u1ec3n l\u1ea1i v\u1ec1 General <\/strong>ho\u1eb7c \u0111\u1ecbnh d\u1ea1ng Date<\/strong> \u0111\u1ec3 h\u00e0m YEAR ho\u1ea1t \u0111\u1ed9ng ch\u00ednh x\u00e1c. Trong tr\u01b0\u1eddng h\u1ee3p \u00f4 ch\u1ec9 c\u00f3 ng\u00e0y v\u00e0 th\u00e1ng m\u00e0 kh\u00f4ng c\u00f3 n\u0103m, Excel s\u1ebd t\u1ef1 hi\u1ec3u n\u0103m hi\u1ec7n t\u1ea1i c\u1ee7a h\u1ec7 th\u1ed1ng.<\/p>\n

      B\u01b0\u1edbc 2:<\/strong> Nh\u1ea5n Enter<\/strong> \u0111\u1ec3 xem k\u1ebft qu\u1ea3 v\u00e0 sao ch\u00e9p c\u00f4ng th\u1ee9c xu\u1ed1ng c\u00e1c \u00f4 c\u00f2n l\u1ea1i n\u1ebfu c\u1ea7n.<\/p>\n

      \"H\u00e0mC\u00e1ch d\u00f9ng h\u00e0m YEAR \u0111\u1ec3 t\u00e1ch n\u0103m t\u1eeb ng\u00e0y th\u00e1ng<\/em><\/p>\n

      V\u00ed d\u1ee5 2: D\u00f9ng h\u00e0m YEAR \u0111\u1ec3 x\u00e1c \u0111\u1ecbnh n\u0103m nhu\u1eadn<\/strong><\/p>\n

      B\u1ea1n c\u00f3 th\u1ec3 ki\u1ec3m tra m\u1ed9t n\u0103m c\u00f3 ph\u1ea3i n\u0103m nhu\u1eadn hay kh\u00f4ng b\u1eb1ng c\u00e1ch k\u1ebft h\u1ee3p c\u00e1c h\u00e0m YEAR, DATE v\u00e0 MONTH. Trong v\u00ed d\u1ee5, \u00f4 C5 d\u00f9ng c\u00f4ng th\u1ee9c:<\/p>\n

      B\u01b0\u1edbc 1<\/strong>: T\u1ea1i \u00f4 c\u1ea7n ki\u1ec3m tra, nh\u1eadp c\u00f4ng th\u1ee9c:<\/p>\n

      =MONTH(DATE(YEAR(A1),2,29))=2<\/p>\n

      B\u01b0\u1edbc 2:<\/strong> Nh\u1ea5n Enter<\/strong>, sau \u0111\u00f3 sao ch\u00e9p c\u00f4ng th\u1ee9c xu\u1ed1ng c\u00e1c d\u00f2ng c\u00f2n l\u1ea1i \u0111\u1ec3 \u00e1p d\u1ee5ng cho to\u00e0n b\u1ed9 danh s\u00e1ch. C\u00f4ng th\u1ee9c s\u1ebd tr\u1ea3 v\u1ec1 TRUE<\/strong> n\u1ebfu n\u0103m trong \u00f4 A1 l\u00e0 n\u0103m nhu\u1eadn, v\u00e0 FALSE<\/strong> n\u1ebfu kh\u00f4ng ph\u1ea3i.<\/p>\n

      \"C\u00f4ngKi\u1ec3m tra n\u0103m nhu\u1eadn b\u1eb1ng c\u00f4ng th\u1ee9c YEAR \u2013 DATE \u2013 MONTH<\/em><\/p>\n

      Xem th\u00eam: <\/strong>H\u01b0\u1edbng d\u1eabn \u0111\u1ecbnh d\u1ea1ng ng\u00e0y th\u00e1ng n\u0103m trong Excel chi ti\u1ebft v\u00e0 d\u1ec5 th\u1ef1c hi\u1ec7n<\/div>\n
      \n

      3. C\u00e1ch k\u1ebft h\u1ee3p h\u00e0m YEAR v\u1edbi c\u00e1c h\u00e0m kh\u00e1c trong Excel<\/h2>\n<\/div>\n
      \n

      3.1. K\u1ebft h\u1ee3p v\u1edbi h\u00e0m SUMIF<\/h3>\n<\/div>\n

      H\u00e0m YEAR c\u00f3 th\u1ec3 d\u00f9ng chung v\u1edbi SUMIF \u0111\u1ec3 t\u00ednh t\u1ed5ng doanh thu theo t\u1eebng n\u0103m khi b\u1ea3ng d\u1eef li\u1ec7u ch\u1ee9a nhi\u1ec1u ng\u00e0y kh\u00e1c nhau.<\/p>\n

      V\u00ed d\u1ee5: <\/strong>V\u1edbi b\u1ea3ng d\u1eef li\u1ec7u c\u00f3 c\u00e1c ng\u00e0y thu\u1ed9c n\u0103m 2024 v\u00e0 2025, n\u1ebfu mu\u1ed1n t\u00ednh t\u1ed5ng doanh thu c\u1ee7a n\u0103m 2024, b\u1ea1n nh\u1eadp c\u00f4ng th\u1ee9c:<\/p>\n

      =SUMIF(C2:C7, 2024, B2:B7)<\/p>\n

      Trong \u0111\u00f3:<\/strong><\/p>\n

        \n
      • C2:C7: <\/strong>c\u1ed9t ch\u1ee9a n\u0103m \u0111\u00e3 t\u00e1ch ra b\u1eb1ng h\u00e0m YEAR<\/li>\n
      • 2024: <\/strong>n\u0103m c\u1ea7n t\u00ednh t\u1ed5ng<\/li>\n
      • B2:B7: <\/strong>c\u1ed9t doanh thu t\u01b0\u01a1ng \u1ee9ng<\/li>\n<\/ul>\n

        K\u1ebft qu\u1ea3 tr\u1ea3 v\u1ec1 l\u00e0 361, ch\u00ednh l\u00e0 t\u1ed5ng doanh thu c\u1ee7a to\u00e0n b\u1ed9 c\u00e1c ng\u00e0y thu\u1ed9c n\u0103m 2024.<\/p>\n

        T\u01b0\u01a1ng t\u1ef1, n\u1ebfu nh\u1eadp n\u0103m 2025, k\u1ebft qu\u1ea3 s\u1ebd l\u00e0 235.<\/p>\n

        \"T\u00ednhT\u00ednh t\u1ed5ng doanh thu n\u0103m 2024 v\u00e0 2025 b\u1eb1ng h\u00e0m SUMIF<\/em><\/p>\n

        \n

        3.2. K\u1ebft h\u1ee3p v\u1edbi h\u00e0m SUMPRODUCT<\/h3>\n<\/div>\n

        B\u1ea1n c\u0169ng c\u00f3 th\u1ec3 d\u00f9ng YEAR c\u00f9ng SUMPRODUCT \u0111\u1ec3 t\u00ednh t\u1ed5ng doanh thu theo t\u1eebng n\u0103m m\u00e0 kh\u00f4ng c\u1ea7n t\u1ea1o c\u1ed9t ph\u1ee5.<\/p>\n

        T\u1ea1i \u00f4 F2, c\u00f4ng th\u1ee9c \u00e1p d\u1ee5ng cho d\u1eef li\u1ec7u c\u1ee7a b\u1ea1n l\u00e0:<\/p>\n

        =SUMPRODUCT((YEAR(A2:A7)=2024)*B2:B7)<\/p>\n

        Trong \u0111\u00f3:<\/strong><\/p>\n

          \n
        • YEAR(A2:A7)=2024 <\/strong>d\u00f9ng \u0111\u1ec3 ki\u1ec3m tra c\u00e1c ng\u00e0y thu\u1ed9c n\u0103m 2024.<\/li>\n
        • B2:B7<\/strong> l\u00e0 c\u1ed9t doanh thu t\u01b0\u01a1ng \u1ee9ng.<\/li>\n<\/ul>\n

          Nh\u1ea5n Enter<\/strong> \u0111\u1ec3 l\u1ea5y k\u1ebft qu\u1ea3. Sau \u0111\u00f3 b\u1ea1n ch\u1ec9 c\u1ea7n \u0111\u1ed5i n\u0103m trong c\u00f4ng th\u1ee9c ho\u1eb7c k\u00e9o c\u00f4ng th\u1ee9c xu\u1ed1ng \u0111\u1ec3 t\u00ednh cho n\u0103m ti\u1ebfp theo.<\/p>\n

          \"T\u00ednhT\u00ednh t\u1ed5ng doanh thu theo n\u0103m b\u1eb1ng h\u00e0m SUMPRODUCT<\/em><\/p>\n

          \n

          4. L\u1ed7i th\u01b0\u1eddng g\u1eb7p khi s\u1eed d\u1ee5ng h\u00e0m YEAR<\/h2>\n<\/div>\n
          \n

          4.1. L\u1ed7i #VALUE<\/h3>\n<\/div>\n
            \n
          • Nguy\u00ean nh\u00e2n:<\/strong> L\u1ed7i n\u00e0y xu\u1ea5t hi\u1ec7n khi gi\u00e1 tr\u1ecb trong \u00f4 kh\u00f4ng ph\u1ea3i \u0111\u1ecbnh d\u1ea1ng ng\u00e0y h\u1ee3p l\u1ec7, th\u01b0\u1eddng l\u00e0 d\u1eef li\u1ec7u \u0111ang \u1edf d\u1ea1ng v\u0103n b\u1ea3n (TEXT) ho\u1eb7c \u0111\u01b0\u1ee3c nh\u1eadp sai c\u1ea5u tr\u00fac.<\/li>\n
          • C\u00e1ch kh\u1eafc ph\u1ee5c:<\/strong> Xem l\u1ea1i \u0111\u1ecbnh d\u1ea1ng c\u1ee7a \u00f4 ch\u1ee9a ng\u00e0y v\u00e0 chuy\u1ec3n v\u1ec1 General, Date ho\u1eb7c Number \u0111\u1ec3 Excel nh\u1eadn di\u1ec7n \u0111\u00fang ki\u1ec3u d\u1eef li\u1ec7u tr\u01b0\u1edbc khi \u00e1p d\u1ee5ng h\u00e0m YEAR.<\/li>\n<\/ul>\n

            \"L\u1ed7iL\u1ed7i #VALUE x\u1ea3y ra khi d\u1eef li\u1ec7u ng\u00e0y kh\u00f4ng \u0111\u00fang \u0111\u1ecbnh d\u1ea1ng<\/em><\/p>\n

            \n

            4.2. L\u1ed7i #NAME<\/h3>\n<\/div>\n
              \n
            • Nguy\u00ean nh\u00e2n:<\/strong> L\u1ed7i n\u00e0y th\u01b0\u1eddng x\u1ea3y ra khi t\u00ean h\u00e0m ho\u1eb7c k\u00fd t\u1ef1 trong c\u00f4ng th\u1ee9c \u0111\u01b0\u1ee3c nh\u1eadp sai.<\/li>\n
            • C\u00e1ch kh\u1eafc ph\u1ee5c:<\/strong> R\u00e0 so\u00e1t l\u1ea1i to\u00e0n b\u1ed9 c\u00f4ng th\u1ee9c \u0111\u1ec3 b\u1ea3o \u0111\u1ea3m t\u00ean h\u00e0m v\u00e0 c\u00fa ph\u00e1p \u0111\u1ec1u ch\u00ednh x\u00e1c. N\u1ebfu v\u1eabn ch\u01b0a x\u00e1c \u0111\u1ecbnh \u0111\u01b0\u1ee3c l\u1ed7i, b\u1ea1n c\u00f3 th\u1ec3 b\u1ea5m v\u00e0o bi\u1ec3u t\u01b0\u1ee3ng c\u1ea3nh b\u00e1o (d\u1ea5u ch\u1ea5m than m\u00e0u v\u00e0ng) xu\u1ea5t hi\u1ec7n c\u1ea1nh \u00f4 \u0111\u1ec3 xem g\u1ee3i \u00fd s\u1eeda l\u1ed7i t\u1eeb Excel.<\/li>\n<\/ul>\n

              \"L\u1ed7iL\u1ed7i #NAME? do nh\u1eadp sai c\u00fa ph\u00e1p h\u00e0m YEAR<\/em><\/p>\n

              H\u00e0m YEAR gi\u00fap b\u1ea1n x\u1eed l\u00fd d\u1eef li\u1ec7u th\u1eddi gian nhanh g\u1ecdn v\u00e0 ch\u00ednh x\u00e1c h\u01a1n trong Excel, \u0111\u1eb7c bi\u1ec7t khi k\u1ebft h\u1ee3p c\u00f9ng SUMIF ho\u1eb7c SUMPRODUCT. \u0110\u1ec3 xem th\u00eam nhi\u1ec1u m\u1eb9o Excel h\u1eefu \u00edch, h\u00e3y theo d\u00f5i chuy\u00ean m\u1ee5c Kinh nghi\u1ec7m c\u1ee7a Si\u00eau Th\u1ecb \u0110i\u1ec7n M\u00e1y – N\u1ed9i Th\u1ea5t Ch\u1ee3 L\u1edbn.<\/p>\n

              N\u1ebfu b\u1ea1n c\u1ea7n m\u1ed9t thi\u1ebft b\u1ecb ti\u1ec7n l\u1ee3i \u0111\u1ec3 h\u1ecdc Excel m\u1ecdi l\u00fac m\u1ecdi n\u01a1i, \u0111\u1eebng qu\u00ean tham kh\u1ea3o c\u00e1c d\u00f2ng \u0111i\u1ec7n tho\u1ea1i v\u00e0 m\u00e1y t\u00ednh b\u1ea3ng \u0111ang \u0111\u01b0\u1ee3c \u01b0u \u0111\u00e3i t\u1ea1i Si\u00eau Th\u1ecb \u0110i\u1ec7n M\u00e1y – N\u1ed9i Th\u1ea5t Ch\u1ee3 L\u1edbn.<\/p>\n<\/div>\n","protected":false},"excerpt":{"rendered":"

              \u00a0 Khi l\u00e0m vi\u1ec7c v\u1edbi d\u1eef li\u1ec7u theo th\u1eddi gian, vi\u1ec7c l\u1ea5y nhanh ph\u1ea7n n\u0103m t\u1eeb m\u1ed9t ng\u00e0y c\u1ee5 th\u1ec3 gi\u00fap b\u1ea1n x\u1eed l\u00fd v\u00e0 t\u1ed5ng h\u1ee3p th\u00f4ng tin ch\u00ednh x\u00e1c h\u01a1n. Trong b\u00e0i vi\u1ebft n\u00e0y, b\u1ea1n s\u1ebd \u0111\u01b0\u1ee3c h\u01b0\u1edbng d\u1eabn c\u00e1ch d\u00f9ng h\u00e0m YEAR trong Excel, c\u00f9ng c\u00e1c v\u00ed d\u1ee5 minh h\u1ecda gi\u00fap b\u1ea1n […]<\/p>\n","protected":false},"author":1,"featured_media":4964,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[8],"tags":[],"class_list":["post-4963","post","type-post","status-publish","format-standard","has-post-thumbnail","hentry","category-thu-thuat"],"jetpack_featured_media_url":"https:\/\/autofillform.com\/blog\/wp-content\/uploads\/2025\/11\/19394.jpg","_links":{"self":[{"href":"https:\/\/autofillform.com\/blog\/wp-json\/wp\/v2\/posts\/4963","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/autofillform.com\/blog\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/autofillform.com\/blog\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/autofillform.com\/blog\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/autofillform.com\/blog\/wp-json\/wp\/v2\/comments?post=4963"}],"version-history":[{"count":0,"href":"https:\/\/autofillform.com\/blog\/wp-json\/wp\/v2\/posts\/4963\/revisions"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/autofillform.com\/blog\/wp-json\/wp\/v2\/media\/4964"}],"wp:attachment":[{"href":"https:\/\/autofillform.com\/blog\/wp-json\/wp\/v2\/media?parent=4963"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/autofillform.com\/blog\/wp-json\/wp\/v2\/categories?post=4963"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/autofillform.com\/blog\/wp-json\/wp\/v2\/tags?post=4963"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}