Office Status Calendar

My company has been researching on how to track the status of the employees working in office. We created a sheet where each day of the week, not including weekends, is a dropdown column with the choices of:

• IN OFFICE

• REMOTE

• OUT OF OFFICE

We also use conditional formatting for each column where if it selection is IN OFFICE then the cell turns green, but it is such a hassle to keep putting each of until the end of the year.

The question we have been trying to answer is there a better and more refined way of tracking it.

Attached is a excel of what it sort of looks like, due trying to keep names and other information out.

Can someone look it over and give me some advice?

Answers