close

The formula quot;networkdaysquot; doesn't seem to work when there is a year change. I
hope someone has a solution for this.


Networkdays has no problem with year changes in my experience.

Can you post an example of data where you get an incorrect
result/error?--
daddylonglegs
------------------------------------------------------------------------
daddylonglegs's Profile: www.excelforum.com/member.php...oamp;userid=30486
View this thread: www.excelforum.com/showthread...hreadid=520302Hi, I think I found the error that caused the issue: the start date was equal
to one of the holidays...
Thanks for your posting anyway
quot;daddylonglegsquot; wrote:

gt;
gt; Networkdays has no problem with year changes in my experience.
gt;
gt; Can you post an example of data where you get an incorrect
gt; result/error?
gt;
gt;
gt; --
gt; daddylonglegs
gt; ------------------------------------------------------------------------
gt; daddylonglegs's Profile: www.excelforum.com/member.php...oamp;userid=30486
gt; View this thread: www.excelforum.com/showthread...hreadid=520302
gt;
gt;

arrow
arrow
    全站熱搜
    創作者介紹
    創作者 software 的頭像
    software

    software

    software 發表在 痞客邦 留言(0) 人氣()