係,
所以我每一行ColumA 要用三行去做.
第一行用黎搵”,"
第二行拆String變做一個個日字.
第三行count 數.
不過仲有過快少少的方法.
A1: "14-19/08, 11/09, 29-30/10, 21-24/11"
B1: =LEN(A1)-LEN(SUBSTITUTE(A1,"/",""))+SUM(C1:G1)
C1: =IFERROR(VALUE(TRIM(MID($A1,SEARCH("#",SUBSTITUTE($A1,"-","#",COLUMN()-COLUMN($C1)+1),1)+1,2))-VALUE(TRIM(MID($A1,SEARCH("#",SUBSTITUTE($A1,"-","#",COLUMN()-COLUMN($C1)+1),1)-2,2)))),"")
C1 copy to D1 ~G1