Formula for dates minus the weekends

G

Guest

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

Guest

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

Dates formula 5
CALCULATE BETWEEN TWO DATES EXCLUDING WEEKENDS 3
Aging Report 7
dates for on time delivery calc. 3
Skip weekends 1
What formula do I need? 3
Date calculation 1
Value error with this formula 5

Top