May 2021 1 31 Report
請問excel 裡的某日期增加【減去假日及國定假日、彈性放價,增加假日補班】20個工作天,應該用什麼樣的公式呢 目前使用 =WORKDAY(C12,20,$A$34:$A$48)+SUMPRODUCT($C$34:$C$48>=C12) 但是中間有經過補班日的話出來的日期總是不對?

Please enter comments
Please enter your name.
Please enter the correct email address.
You must agree before submitting.

Answers & Comments


Helpful Social

Copyright © 2024 1QUIZZ.COM - All rights reserved.