2 Replies Latest reply on Jun 21, 2013 10:19 AM by Elizabeth Coleman

    If Statement with multiple criteria

    Elizabeth Coleman


      I'm trying to create an If statement with multiple criteria that looks like this.


      If (Install Complete Plan Date) = " " or '01/01/01' Then 'Unscheduled'

      ElseIf (Install Complete Plan Date) = "MM/DD/YY" (represents date within current year) then 'Scheduled'

      Else (Install Complete Plan Date) = "MM/DD/YY" (represents date with next year) then 'Next Fiscal Year'


      I don't know what is needed so the formula recognize the date within 2013 vs. 2014.  Any help is appreciated.