I'm setting up a spreadsheet that includes arrival and departure dates for
about 500 people. I'm trying to set it up so that I can figure out who will
be present on a given day. For example All people who will be present on
March 5. That range would include people arriving January 15 and departing on
March 6, but also people arriving March 5 and departing on April 10.

Any suggestions on setting up a function and sort command combination that
would allow me to do this.

Thanks