One for all,all for one.: VBA 計算日期相差天數 (扣掉六日)

2012年4月10日星期二

DateDiff("d", Before, Today) - (Ceiling((DateDiff("d", Before, Today) - (Format(Today, "w") - 1)) / 7) * 2)

One for all,all for one.