1 min readfrom Microsoft Excel | Help & Support with your Formula, Macro, and VBA problems | A Reddit Community

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

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

Want to read more?

Check out the full article on the original site

View original article

Tagged with

#financial modeling with spreadsheets
#row zero
#rows.com
#AI formula generation techniques
#modern spreadsheet innovations
#machine learning in spreadsheet applications
#enterprise-level spreadsheet solutions
#digital transformation in spreadsheet software
#Excel compatibility
#large dataset processing
#collaborative spreadsheet tools
#AI-driven spreadsheet solutions
#cloud-based spreadsheet applications
#Excel alternatives for data analysis
#automation in spreadsheet workflows
#no-code spreadsheet solutions
#AI-powered spreadsheet
#formula generator
#Excel alternatives
#spreadsheet API integration