calculate per day usage with a number range

Giganews Newsgroups
Subject: calculate per day usage with a number range
Posted by:  peabody
Date: Sun, 20 Jul 2008

I have the check in date and the check out date for a large group.  I would
like to see how many rooms are used per day for the period.
Column A = Check in date  (ex:  2-feb)
Column B = Check out date (ex: 10-feb)
How can I tell how many rooms were used on 6-feb, how many on 7-feb, etc?

Thanks so much for your help!

Replies