{"id":8234,"date":"2024-12-22T04:20:48","date_gmt":"2024-12-22T04:20:48","guid":{"rendered":"https:\/\/blog.ezworkapp.com\/index.php\/2024\/12\/22\/tinh-so-ngay-thu-6-giua-2-ngay-bat-ki\/"},"modified":"2024-12-22T04:20:48","modified_gmt":"2024-12-22T04:20:48","slug":"tinh-so-ngay-thu-6-giua-2-ngay-bat-ki","status":"publish","type":"post","link":"https:\/\/blog.ezworkapp.com\/index.php\/2024\/12\/22\/tinh-so-ngay-thu-6-giua-2-ngay-bat-ki\/","title":{"rendered":"T\u00ednh s\u1ed1 ng\u00e0y th\u1ee9 6 gi\u1eefa 2 ng\u00e0y b\u1ea5t k\u00ec"},"content":{"rendered":"
\n

T\u00ednh s\u1ed1 ng\u00e0y th\u1ee9 6, th\u1ee9 5, th\u1ee9 4, ch\u1ee7 nh\u1ea5t, v.v\u2026 gi\u1eefa 2 ng\u00e0y b\u1ea5t k\u00ec, \u0111\u00e3 bao gi\u1edd b\u1ea1n ph\u1ea3i l\u00e0m \u0111i\u1ec1u n\u00e0y? Sau \u0111\u00e2y l\u00e0 v\u00ed d\u1ee5 v\u00e0 c\u00f4ng th\u1ee9c<\/p>\n

\"tinh-so-thu-6-giua-2-ngay-bat-ki\"<\/p>\n

V\u1edbi y\u00eau c\u1ea7u tr\u00ean, nh\u1eefng c\u00f4ng th\u1ee9c sau \u0111\u00e2y c\u00f3 th\u1ec3 \u0111\u01b0a ra k\u1ebft qu\u1ea3 l\u00e0 14 ng\u00e0y th\u1ee9 6:<\/p>\n\n\n<\/colgroup>\n\n\n\n\n\n\n
CT1<\/td>\n=SUMPRODUCT(\u2013(WEEKDAY(ROW(INDIRECT(A1&\u201d:\u201d&A2)))=6<\/span>))<\/td>\n<\/tr>\n
CT2<\/td>\n=SUMPRODUCT(N(WEEKDAY(ROW(INDIRECT(A1&\u201d:\u201d&A2)))=6<\/span>))<\/td>\n<\/tr>\n
CT3<\/td>\n=SUMPRODUCT(\u2013(TEXT(ROW(INDIRECT(A1&\u201d:\u201d&A2)),\u201dDDDD\u201d)=\u201dFriday<\/span>\u201c))<\/td>\n<\/tr>\n
CT4<\/td>\n{=SUM(\u2013(WEEKDAY(ROW(INDIRECT(A1&\u201d:\u201d&A2)))=6<\/span>))}<\/td>\n<\/tr>\n
CT5<\/td>\n=INT((A2-A1+WEEKDAY(A1,16<\/span>))\/7)<\/td>\n<\/tr>\n<\/tbody>\n<\/table>\n

Ch\u00fa \u00fd:<\/p>\n