formula for calculating # of days between 2 cells
 

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.

=Networkdays(a1,a2)
after installing analsis took pack addin
"Lois" wrote in message
...
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??

"N Harkawat" wrote:

=Networkdays(a1,a2)
after installing analsis took pack addin
"Lois" wrote in message
...
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.

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

"Lois" wrote in message
...
Can't get it to work. don't understand the part about after installing
analysis took pack addin??

"N Harkawat" wrote:

=Networkdays(a1,a2)
after installing analsis took pack addin
"Lois" wrote in message
...
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.

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

"N Harkawat" wrote in message
...
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

"Lois" wrote in message
...
Can't get it to work. don't understand the part about after installing
analysis took pack addin??

"N Harkawat" wrote:

=Networkdays(a1,a2)
after installing analsis took pack addin
"Lois" wrote in message
...
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.

THANK YOU THANK YOU THANK YOU! IT WORKED!!!!

"N Harkawat" wrote:

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

"Lois" wrote in message
...
Can't get it to work. don't understand the part about after installing
analysis took pack addin??

"N Harkawat" wrote:

=Networkdays(a1,a2)
after installing analsis took pack addin
"Lois" wrote in message
...
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.