Determine if task has upcoming due date

Hi All,
I am trying to figure out if a particular task has an upcming due date by seeing if a particular date field falls within 4 weeks from today.
I have written the following formula:
IF(AND({Milestone_Current_Due_Date} <= DATEADD(TODAY(), 1, ‘month’)),{Milestone Status}!=‘Completed’, “Upcoming Due Date”)

But as you can tell from this screenshot it does not seem to operating correctly, saying some tasks have an upcming due date that is not within 4 weeks.


Hi Gabriel,
Looking at your formula, you have Milestone Status to equal Completed. Your screenshot shows the status as Incomplete. I think the formula needs to say Incomplete or you need to select Complete in Milestone Status to keep your formula as is.

The formula actuatally is using !=, which means “do not equal”, so that isn’t the issue. The closing parenthesis for the AND() statement is in the wrong place:

IF(
   AND(
      {Milestone_Current_Due_Date} <= DATEADD(TODAY(), 1, "month"),
      {Milestone Status}!="Completed"
   ), 
   "Upcoming Due Date"
)
1 Like

WOW thanks so much! :grinning:

This topic was solved and automatically closed 15 days after the last reply. New replies are no longer allowed.