Desperate for help with a formula

Sharon Kokkines

I need help with a formula.  I want to look at a revised date and the original due date, and have the value that is greater in another column for formatting purposes.  Here is what I am using. 

=IF(([Revised Due Date]734 - [Due Date]734)>0, [Revised Due Date]734, [Due Date]734).  Can someone help me ?   Thanks, Sharon

Johnny Rox

Hey Sharon,

 

You could do something like this:

=IF([Revised Due Date]1 > [Due Date]1, [Revised Due Date]1, [Due Date]1)

 

So, if the revised date is greater than the due date, show the revised date. Otherwise show that due date.

 

 

Here's another way: =MAX([Completion Due Date]1:[Due Date]1)

 

This is just grabbing the max date in that range.