起止日期用小數點 計算天數 (14275)

E2=SUBSTITUTE(2025+(MID(C2,FIND("-",C2)+1,9)-LEFT(C2,FIND("-",C2)-1)<0)&"/"&MID(C2,FIND("-",C2)+1,9),".","/")-SUBSTITUTE(2025&"/"&LEFT(C2,FIND("-",C2)-1),".","/")+1

另解=SUM((2025+{0,1}*(SUM(MID(SUBSTITUTE(C2,"-",REPT(" ",9)),{1,9},10)*{-1,1})<0)&"/"&TRIM(MID(SUBSTITUTE(SUBSTITUTE(C2,"-",REPT(" ",9)),".","/"),{1,9},10)))*{-1,1})+1

另解=NPV(-2,(2025+{0,1}*(SUM(MID(SUBSTITUTE(C2,"-",REPT(" ",9)),{1,9},10)*{-1,1})<0)&"/"&SUBSTITUTE(TEXT({1,-1}%,SUBSTITUTE(C2,"-",";")),".","-"))*1)+1