need to keep track of work prepared and work done

[exterminator]

I'm a exterminater of an 1100 apartment complex of 6 buildings and I prepare
apartments for exterminations and I go back an exterminate them I need to be
able to remember which ones are already prepared and ready to be sprayed
,some kind of system. helppppppppp please.

 

[deebs]

Use an Excel spreadsheet.

Conditional formatting on date will help to indicate what ones are due,
overdue or soon due.