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!
|