NETWORKDAYS - 30 calculation HELP!

[ajpowers]

How do I use the "networkdays" formula to determine when a produc
should ship by?

I have a PO issue date and a shipment due date, I need to calculate
"Should ship by date". I know that it takes 30 days on the water, an
I can't include weekends. Help

 

[Ron Rosenfeld]

How do I use the "networkdays" formula to determine when a product
should ship by?

I have a PO issue date and a shipment due date, I need to calculate a
"Should ship by date". I know that it takes 30 days on the water, and
I can't include weekends. Help!

I'm curious as to why weekends are excluded when shipping by water. I thought
ships traveled 24/7.

In any event, you want to use the WORKDAY formula, if you need to exclude
weekends.

=WORKDAY(shipment_due_date, -30) or
=workday(shipment_due_date,-shipping_days)

On the other hand, if you merely want to exclude the WEEKEND as a possible
"should ship by date", then use this variation:

=workday(shipment_due_date-shipping_days+1,-1) or
=workday(shipment_due_date-30+1,-1)


--ron