Calculating number of days

C

Carlos

I have two columns with date filled in. For example one of
the columns has a date of 02/23/05 the second columns has
a date of 03/01/05. What I need is to calculate the
number of day between the two dates minus the weekend
days. Can anyone help me.
 
J

Jason Morin

Check out the NETWORKDAYS worksheet function in Excel
Help.

HTH
Jason
Atlanta, GA
 
P

Peo Sjoblom

Look at NETWORKDAYS, you need to have ATP installed but it comes with
excel/office

=NETWORKDAYS(start,end,holidays)

could look like

=NETWORKDAYS(A1,B1,H2:H10)
 
B

Bob Phillips

Take a look at the NETWORKDAYS function, which needs the Analysis Toolpak to
be installed.

--

HTH

RP
(remove nothere from the email address if mailing direct)
 

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

Average days between dates 3
Help with Excel 2007 COUNTIFS! 0
Sum the difference between dates given a certain criteria 5
Sum amounts based on date field 6
How to get largest date from a Vlookup 1
Calculate elapsed time excluding specific timeframe 10
Termination within number of days 5
Complex function needed? 5

Top