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;
- Jul 20 Thu 2006 20:08
working hours
close
全站熱搜
留言列表
發表留言