excel日期+天數扣除隔周休 - 工作
By Suhail Hany
at 2013-11-07T00:00
at 2013-11-07T00:00
Table of Contents
假如今天11/7而需要計算10天後的日期,但是須扣除周末休息時間請問公式該怎麼寫?原本以為workday的holidays是可以選取範圍只扣除另外的休息時間結果似乎是周末兩天都扣除了...(因公司是隔周休)例如:a1:a5是休息的日期=WORKDAY(TODAY(),10,a1:a5)已經查了很多地方可是幾乎都是周末兩天都會扣除..請幫忙解答>"<...Showmore
Tags:
工作
All Comments
By Hazel
at 2013-11-07T16:59
at 2013-11-07T16:59
By Jacky
at 2013-11-08T08:23
at 2013-11-08T08:23
By George
at 2013-11-10T10:15
at 2013-11-10T10:15
By Anthony
at 2013-11-08T21:52
at 2013-11-08T21:52
By Michael
at 2013-11-08T21:34
at 2013-11-08T21:34
Related Posts
車禍賠償書被拿去告詐欺怎麼辦??
By Elvira
at 2013-11-07T00:00
at 2013-11-07T00:00
車禍理賠處理?
By Faithe
at 2013-11-07T00:00
at 2013-11-07T00:00
很急~請幫幫我與媽媽~關於車禍
By Sierra Rose
at 2013-11-07T00:00
at 2013-11-07T00:00
找工作(米卦)
By Poppy
at 2013-11-07T00:00
at 2013-11-07T00:00
請問房子風水,有大門壁刀煞與房門斜切問題如何改善
By Cara
at 2013-11-07T00:00
at 2013-11-07T00:00