IF/OR statement to compare 2 sets of dates (4 fields total)

I’m trying to create a formula whereby :

IF Fdate 1] is after rdate 2] OR Rdate 3] is after rdate 4] to tell me “Needs Review”, otherwise “Updated”.

How do i do this? i’m not sure how to compare the date fields.

Thanks!

Page 1 / 1

IF(

   OR(

      {Date 1} > {Date 2},

      {Date 3} > {Date 4}      

   ),

   "Needs Review",

   "Updated"

)

Sign up