Formulas to show overdue and coming due tasks
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
[link] [comments]
Want to read more?
Check out the full article on the original site