One for all,all for one.: VBA 計算日期相差天數

DateDiff("d", dtmValue1, dtmValue2)

Reference :
DateDiff Function

One for all,all for one.