Excelquestion35
Board Regular
- Joined
- Nov 29, 2021
- Messages
- 53
- Office Version
- 2016
- Platform
- Windows
Hi all,
Got a quite simpple formula that needs some adjustment but can get it solved.
What I'm trying to do is keeping track of my tasks in Excel, for that I want to warn myself whether I will have some conflicts in my schedule.
For that reason I used below code which calculates if I have more than 3 tasks due in the next 7 days, it should say yes. However I won't delete the tasks in my list, so it should exclude the list of tasks that were already completed in this period. I tried something myself as shown below by referring to column H which contains the value 'DONE' when some task has been completed. However, it does not work as intended.
Got a quite simpple formula that needs some adjustment but can get it solved.
What I'm trying to do is keeping track of my tasks in Excel, for that I want to warn myself whether I will have some conflicts in my schedule.
For that reason I used below code which calculates if I have more than 3 tasks due in the next 7 days, it should say yes. However I won't delete the tasks in my list, so it should exclude the list of tasks that were already completed in this period. I tried something myself as shown below by referring to column H which contains the value 'DONE' when some task has been completed. However, it does not work as intended.
VBA Code:
IF(COUNTIFS($E$2:$E$60;">="&TODAY()+1;$E$2:$E$60;"<="&TODAY()+7)>3-COUNTIFS(H2:H60;"DONE");"YES";"NO")
