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

 

[Fluff]

Please see post#8

 

[Andrew Skibbz]

Hi,

This formula is not working, please advise

 

[DanteAmor]

I think we are already confused, you can put an example of your data, where you can see the titles of the table.7

Or


You could upload a copy of your file to a free site such as www.box.com or www.dropbox.com. Once you do that, mark it for 'Sharing' and you will be given a link to the file that you can post here. If the workbook contains confidential information, you could replace it with generic data.

 

[Andrew Skibbz]

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

 

[Andrew Skibbz]

Okay, so above formula just needs to include "Completed" or "Cancelled"

 

[Fluff]

Have you tried the suggestion in post#3?

 

[Andrew Skibbz]

Post 3 does not work

 

[Andrew Skibbz]

This can't be difficult.

In short.
Column A - various dates
Column B - Status (Completed, Cancelled, Processing etc...)

All I want in Column C is:

If Date in Column A and Status in Column B is less than today's date and not equal to "Completed or Cancelled", move to today's date.

 

[Fluff]

In that case how about
=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]

Its says if entered too many arguments....