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