←Back to Beyond Market Intelligence
•1 min read•from Microsoft Excel | Help & Support with your Formula, Macro, and VBA problems | A Reddit Community

Formulas to show overdue and coming due tasks

Our take

Managing tasks efficiently is crucial for productivity, especially when dealing with due dates in large spreadsheets. In this scenario, you have a comprehensive list of tasks alongside their due dates, but you need to separate overdue tasks from those coming due in the next 14 days. The current formula pulls both categories into one list, creating confusion.

I have a large spreadsheet with a list of tasks in one column. In another column I have a due date.

I have another tab that shows progress on the status's of the tasks. This includes a list that pulls all of the tasks that are overdue. It also has another list that is supposed to pull all of the tasks that are coming due in 14 days. Right now it pulls all tasks that are overdue and coming due. I would like these to be two separate lists. Can someone help me with how to write this formula so it will exclude the tasks that are overdue.

=INDEX(ProjectTasks_ByRegion!$A$1:$A$350,SMALL(IF(ProjectTasks_ByRegion!$L$1:$L$350<=TODAY()+14,ROW(ProjectTasks_ByRegion!$A$1:$A$350)),ROW(1:1)))

A is the column with the Task Name and L is the column with the Due Date

submitted by /u/Starbird3
[link] [comments]

Read on the original site

Open the publisher's page for the full experience

View original article →

Related Articles

Tagged with

#rows.com