Skip to main content

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.

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"
)

WOW thanks so much! :grinning:

Terms & ConditionsAccessibility statement