View Single Post
  #1   Report Post  
pumper
 
Posts: n/a
Default 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?