Calculating number of days

  • Thread starter Thread starter Carlos
  • Start date Start date
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.
 
Check out the NETWORKDAYS worksheet function in Excel
Help.

HTH
Jason
Atlanta, GA
 
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)
 
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)
 
You must log in or register to reply here.

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

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

Back
Top