Formula for dates minus the weekends
 

I need help finding a formula that will figure out the days minus weekend days.

Ex: Due date Ship date #of days early # of days late
4/16/07 4/26/07 7

I would like for the # of days early or # of days late to give me a # BUT
not counting weekend days. Is there anyway to do this?
--
TJH

Formula for dates minus the weekends
 

look at networkdays() in help. note you must have the data analysis addin
activated for it to work.

"TJH" wrote:

I need help finding a formula that will figure out the days minus weekend days.

Ex: Due date Ship date #of days early # of days late
4/16/07 4/26/07 7

I would like for the # of days early or # of days late to give me a # BUT
not counting weekend days. Is there anyway to do this?
--
TJH