Excel Task Deadlines Automation

I have an existing Excel project-tracker and I need it to tell me, at a glance, exactly which tasks are due, which are overdue, and how many days remain before each deadline. Right now the data is all there—task names, owners, start-finish dates—but the sheet is static...