Calculating for number of days when values are in dates

[Guest]

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?

 

[Max]

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 <at>yahoo<dot>com
----

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?

 

[Ron Rosenfeld]

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?

If the check in date is in A1, and the check out date in A2, then =A2-A1 and
format the result as General.


--ron

 

[Guest]

Max,
Thank you for the quick response. The mistake I did was I had C2 formated
as "date" instead of "General". Now it works!

Thanks,

pumper

 

[Guest]

Ron,

I didn't format my result as "General", that's why I kept getting weird
results. I got it now. Thank you.

pumper

 

[Max]

You're welcome !
Thanks for posting back

 

[Guest]

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]

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

Just copy C2 down

Point the cursor at the bottom right corner of C2
(the cursor will change to a "black cross")

Now just left-click and drag down to copy C2 to C3, C4 ... C200 etc