IF(AND(OR Formula

[Andrew Skibbz]

Hi,
I have the following formula:
=IF(AND([@[Received_Date(Final)]]<>””,[@[Received_Date(Final)]]<today(),trim([@[status_name]])<>”Completed”),TODAY()+TIME(7,0,0),[@[Received_Date(Final)]])</today(),trim([@[status_name]])<>

Basically the formula moves a date to today’s date if the status name is not equal to “completed”

I want to change this to move date if not equal to “Completed” or “Cancelled”

Any Help appreciated!

Thanks,
Andrew

 

[Andrew Skibbz]

=IF(AND([@[Received_Date(Final)]]<>"",[@[Received_Date(Final)]]< today(),trim([@[status_name]])<>"Completed"),trim([@[status_name]])<>"Cancelled"),TODAY()+TIME(7,0,0),[@[Received_Date(Final)]])

 

[Andrew Skibbz]

Sorted thanks, was missing a ) after "Completed". works a treat thank you!!!!

 

[Fluff]

Glad it's sorted & thanks for the feedback

 

[DanteAmor]

.

 

[DanteAmor]

Sorry for arriving so late, try this:

=IF(AND([@[Received_Date(Final)]] <> "",[@[Received_Date(Final)]] < TODAY(),[@[status_name]] <> {"Completed","Cancelled"}),TODAY()+TIME(7,0,0),[@[Received_Date(Final)]])