I work for a temporary housing company and would like to create a calendar
where all i have to do is put the clients name and dates they are staying in
a "key" and it will automatically block out that range of date an a calendar
(and preferrable tent the cell red meaning occupied). Does anyone have any
advice on what formula would get this accomplished?

Thank you in advance!!