Andrew Skibbz
New Member
- Joined
- Mar 29, 2017
- Messages
- 28
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
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