错误回答问题......但是线程被锁定了。 [英] Wrong answer to question ... but thread is locked.

问题描述

嘿伙计们，

我一直在寻找这个问题所描述问题的解决方案：

i was looking for a solution for the problem described in this thread:

http：// social .msdn.microsoft.com /论坛/共享点/ EN-US / d6a6b014-C09C-4436-9f18-0f151bae85b5 /计算值列配方换工作日，二，日期，不包括-周末，DATEDIFF间？论坛= sharepointcustomizationlegacy

http://social.msdn.microsoft.com/Forums/sharepoint/en-US/d6a6b014-c09c-4436-9f18-0f151bae85b5/caculated-column-formula-for-workdays-between-two-dates-excluding-weekends-datediff?forum=sharepointcustomizationlegacy

我正在查看标记为答案的公式（如果我没有错）检查它。在我看来，这个答案是不正确的。证明：

I was looking over the formula that was marked as answer and (in case im not wrong) checked it. In my view this answer isnt correct. Proof:

只有一个场景可以证明：假设开始日是星期四，结束是2周后的星期日。由于星期日晚于星期五，IF条件为假，ELSE语句完成。这里只有2个周末从总差额
中取出，尽管在这段时间内有3个。 （因为FLOOR向下舍入会带来错误的结果）。

Just one scenario to show it: Assume starting day is thursday and end is a sunday 2 weeks later for example. Because Sunday is later than Friday the IF-condition is false and the ELSE-statement is done. Here only 2 weekends are taken out of the total difference though there are 3 in this time span. (because the FLOOR rounds down which brings wrong results).

好吧也许需要一些时间来弄清楚这个没有用，但我的主要问题是这个帖子是锁定的我甚至不能讨论或回应，这些人可能使用了错误的公式。

Well maybe it takes some time to figure out not working on this, but my MAIN issue here is that this thread is LOCKED and i cant even discuss or respond and the guys are probably using a wrong formula.

任何帮助/建议？

问候

Patrick

推荐答案

嗨帕特里克，

考虑到你所拥有的主题链接到2009年，我并不完全惊讶它被锁定。 OP似乎仍然是论坛上的活跃用户，但该线程中的其他人至少在几个月（或几年）内都没有活动。

Considering that the thread you've linked to is from 2009, I'm not totally surprised that it's locked. The OP appears to still be an active user here on the forums, but everyone else from that thread hasn't been active for at least a few months (or years).

你总是可以开始一个新线程并提供一个回到该线程的链接作为阅读你线程的任何人的背景。

You can always start a new thread and provide a link back to that thread as background for anyone reading your thread.

这篇关于错误回答问题......但是线程被锁定了。的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！