close

Pls Help!

I'm trying to subtract a delivery date with order received date and it shows
a value...fine....but how do get the formula to ignore weekends to show a
true working working and more accurate number of delivery days.

If you have Analysis ToolPak installed you can use NETWORKDAYS, e.g.

=NETWORKDAYS(A1,B1) where your first date is in A1 and second date in
B1--
daddylonglegs
------------------------------------------------------------------------
daddylonglegs's Profile: www.excelforum.com/member.php...oamp;userid=30486
View this thread: www.excelforum.com/showthread...hreadid=504437Hello,

I suggest to have a look at:
www.sulprobil.com/html/date_formulas.html

HTH,
Bernd

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

    software

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

    E-mail轉寄