Max,

One more question...if I want Column C, i.e., C3 downward all the way (all
the way down, say I have a long spreadsheet) to have the same formula as in
cell reference C2, how do I do that?

pumper

"Max" wrote:

Assuming:

Check-in dates are in col A, A2 down
Check-out dates are in col B, B2 down

and

Length of stay is to be calculated in col C, C2 down

Put in C2: =B2-A2
Format C2 as "General" or "Number" (to zero dp)
Copy C2 down

Col C will return the results you want

--
Rgds
Max
xl 97
---
GMT+8, 1° 22' N 103° 45' E
xdemechanik <atyahoo<dotcom
----
"pumper" wrote in message
...
How do I write the formula if I want to calculate "length of stay", say
hotel
check-in date was 1/1/2005 and check-out date was 1/10/2005? The answer
is
easy, 10-1=9 days, but when it involves dates, how do you put it in a
formula?