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. I want to transform it with modern, spill-enabled array formulas so the information updates itself the moment I change a date or add a new row.

What I expect
• Dynamic formulas (e.g. FILTER, SORT, UNIQUE, LET, IF, SEQUENCE or similar) that pull from my current tables and return:
– today’s due tasks
– overdue tasks, clearly flagged
– rolling countdown of days remaining for every open task
• No macros or external add-ins; formulas only so the file stays lightweight and shareable.
• Integration into my present worksheet layout—no need to rebuild the entire file, just insert the logic and any helper columns you find necessary.
• Clear, inline comments or a short write-up so I can tweak date fields or ranges later without breaking the solution.

Acceptance
I’ll consider the job complete when I can open the tracker, change a task date, and instantly see the updated due/overdue status and day count with zero manual refresh.