Calculating for number of days when values are in dates
 

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?

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?

On Sun, 16 Jan 2005 17:59:04 -0800, pumper
wrote:

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

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

"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?

Ron,

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

pumper

"Ron Rosenfeld" wrote:

On Sun, 16 Jan 2005 17:59:04 -0800, pumper
wrote:

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

You're welcome !
Thanks for posting back
--
Rgds
Max
xl 97
---
GMT+8, 1° 22' N 103° 45' E
xdemechanik <atyahoo<dotcom
----
"pumper" wrote in message
...
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

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?

"pumper" wrote
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

--
Rgds
Max
xl 97
---
GMT+8, 1° 22' N 103° 45' E
xdemechanik <atyahoo<dotcom
----