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!