Forum Discussion
Re: If today's date is greater than a certain date by a number of days
In another cell:
=IF(A6=TODAY()-4, "The date in A6 is four days ago!", "")
or perhaps
=IF(AND(A6<>"", A6<=TODAY()-4), "The date in A6 is four or more days ago", "")
6 Replies
The equation I asked you for was part of a rather complex equation.
I ran into a problem and I think the problem in the Delay equation; so i think shold be set in a more precise way
so I will explain to you the idea of the equation to explain the idea to you in a simple way:
The idea of the equation to control the follow-up of the status of the tasks entered by the the concerned person on a weekly basis
Our week start date will be an important date
Explanation of how status tasks appear:
Didn't complete tasks = A note appears if the week starts and The concerned person hasn't completed any tasks
In Progress = It appears after the concerned person starts filling in the tasks
Tasks completed = Shows after the concerned person have completed all tasks
Delay in monitoring tasks = after five days from the beginning of the week, the observation appears If the concerned person does not fill out any tasks
Task not due = shown if the date is for the following weekI encountered a problem that if the date is for yesterday, the note "The task is not due" appears although it is an earlier date
The problem I'm experiencing is explained in more detail in the attached Excel table
Note: the random dates in the attached excel to see the application of the equation for each tasksand I apologize for the inconvenience
Let's look at column D.
You check for D2<=TODAY()-4, i.e. D2 is 4 or more days before today.
You also check for D2=TODAY(), i.e. D2 is today's date.
If neither is satisfied, the formula continues to the last bit that returns either "task is not due" or "in progress". This will happen if D2 is in the future, but also if D2 is 1, 2 or 3 days before today.
What do you want to happen if D2 is 1, 2 or 3 days before today?
- A beautiful and important question. On the first to the third day, if he did not complete any of the required tasks, I want the note “You didn't complete the tasks” to appear. As soon as the fourth day arrives, a note is supposed to appear that he is “Delay in monitoring tasks.”
- Thank you it's working
