how to count number of days between 2 dates?
 

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!

how to count number of days between 2 dates?
 

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

Tyro

"doyree" wrote in message
...
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!

how to count number of days between 2 dates?
 

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
"doyree" wrote:

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!

how to count number of days between 2 dates?
 

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.

doyree wrote:

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!

--

Dave Peterson

how to count number of days between 2 dates?
 

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

regards
FSt1

"FSt1" wrote:

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
"doyree" wrote:

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!

how to count number of days between 2 dates?
 

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

doyree wrote:

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!

--

Dave Peterson

how to count number of days between 2 dates?
 

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 wrote:

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

doyree wrote:

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!

--

Dave Peterson

--

Dave Peterson

how to count number of days between 2 dates?
 

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

"Dave Peterson" wrote in message
...
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 wrote:

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

doyree wrote:

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!

--

Dave Peterson

--

Dave Peterson

how to count number of days between 2 dates?
 

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?




Tyro wrote:

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

"Dave Peterson" wrote in message
...
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 wrote:

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

doyree wrote:

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!

--

Dave Peterson

--

Dave Peterson

--

Dave Peterson

how to count number of days between 2 dates?
 

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




Tyro wrote:

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

"Dave Peterson" wrote in message
...
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 wrote:

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

doyree wrote:

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!

--

Dave Peterson

--

Dave Peterson

--

Dave Peterson

how to count number of days between 2 dates?
 

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.

Tyro wrote:

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




Tyro wrote:

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

"Dave Peterson" wrote in message
...
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 wrote:

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

doyree wrote:

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!

--

Dave Peterson

--

Dave Peterson

--

Dave Peterson

--

Dave Peterson