Formula for dates minus the weekends

T

TJH

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?
 
B

bj

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

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Receiving unexpected Duration 0
Dates formula 5
count not-overlapping days in a "Table" with Beginning and EndingsDates Specified 0
CALCULATE BETWEEN TWO DATES EXCLUDING WEEKENDS 3
Aging Report 7
Skip weekends 1
dates for on time delivery calc. 3
What formula do I need? 3

Top