formula for calculating # of days between 2 cells

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

Very simple. I work in a very busy and don't have time to read down on the
examples that might be closest to my needs..
Need the exact formula for the following:
If A1= 3/1/2005 and A2=3/20/2005 I need A3 to equal the # of business days
between A1 & A2.
 
Can't get it to work. don't understand the part about after installing
analysis took pack addin??
 
If you are getting a name# error then on the Menu go to
Tools->Addin and select "Analysis Toolpak"

If your error is not "Name# then check your syntax
 
And if you do not have analysis toolpak addin then use
=SUMPRODUCT(--(WEEKDAY(ROW(INDIRECT(A1&":"&A2)),2)<6))
where A1 is the start date and A2 is the end date
 
THANK YOU THANK YOU THANK YOU! IT WORKED!!!!

N Harkawat said:
If you are getting a name# error then on the Menu go to
Tools->Addin and select "Analysis Toolpak"

If your error is not "Name# then check your syntax
Click to expand...
 
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

Scrabble Value calculation for Welsh words 0
Calculate number of days 6
Calculations 1
Calculate Minutes elapset between two cells 4
Creating a formula relating to several cells 2
Excel formula, sum the value cell and if empty cell left blank 0
Formulas in a cell 2
Two functions in one formula. 1

Back
Top