Thanks you for pointing out the resouces.
However I still have a difficult to calculate the time interval.
This is what I have do
column A column B
column C

1
Date in
Date out
interval

2
Jul-03 (mmm,yy)
Aug-04
=datedif(B2,A2,"m")

3
Jan-04
Sep-04




The result is "#NUM!", how should I format cell C2?
Is there any step I went wrong?

Your help would be much appreciated.

LJ

"JE McGimpsey" wrote in message
...
Alternatively, if you want the "time spent" in other units, check out
the DATEDIF function:

http://cpearson.com/excel/datedif.htm


In article ,
"JulieD" wrote:

assume
Date in is cell B2
Date out is cell C2
formula for D2
=C2-B2
format as number to get the number of days that the tenant stayed.


"LJ" wrote in message
...
I am working in the building and have to calculate the time span each
tenant
stayed . I have "date in" and "date out" and "time spent" columuns.
Does
anyone can give the formula for "time spent" column?