how to count number of days between 2 dates?

[doyree]

please help!!

A B
01/28/08 02/03/08

i have two dates shown above in dates format and i would like to count the
days between those dates.

i tried
=NETWORKDAYS(B2,A2) but got #NAME?

can someone please help?

thank you!

 

[Tyro]

Are you trying to count the number of days between the two dates or the
number of workdays?

Tyro

 

[FSt1]

hi
understand how excel keeps dates
format both dates to general. you will see that they are just numbers
in c1 put this formula.
=b1-a1 answer = 6 days
format c1 to general
format a1 and b1 to date.
it's simple arithmatic.
as to getting #name? on net workdays. you may not have the analysis tool
pack installed.

Regards
FSt1

 

[Dave Peterson]

You have to install the analysis toolpak.

Tools|Addins|check Analysis Toolpak

If it's not listed there, you'll have to install it from the Office CD.

 

[FSt1]

hi.
perhaps i should have answered tyro's question first.
the formula i gave will only show days between dates not workdays.

regards
FSt1

 

[Tyro]

"i have two dates shown above in dates format and i would like to count the
days between those dates."

Does not require the installation of the Analysis Toolpak.

Tyro

 

[Dave Peterson]

i tried
=NETWORKDAYS(B2,A2) but got #NAME?

=Networkdays() does require the analysis toolpak in xl2003 and below.

I wasn't addressing what formula to use.

 

[Tyro]

The OP said he wanted to count the days between two dates. It's simple
subtraction, not NETWORKDAYS,

 

[Dave Peterson]

If you are certain what the original intent was, why post your first response:

Are you trying to count the number of days between the two dates or the
number of workdays?

The OP said he wanted to count the days between two dates. It's simple
subtraction, not NETWORKDAYS,

 

[Tyro]

Because he said he wanted to count the number of days between two dates,
subtraction, and then used NETWORKDAYS in his formula. That is why I asked:
which one do you want?

Tyro

 

[Dave Peterson]

Then why are you complaining about my post about loading the analysis toolpak?

I didn't see a response from the OP that would answer your question and remove
the ambiguity.

Because he said he wanted to count the number of days between two dates,
subtraction, and then used NETWORKDAYS in his formula. That is why I asked:
which one do you want?

Tyro