Comparing dates

[Taskmaster]

I am trying to compare dates across 4 different columns. Here is the formula I need help with  - 

IF

(DATETIME_DIFF(({Start (from Roadmap)}, {M's Start Date}) /This is trying to compare dates in two columns

OR / This is to ensure the second set of date comparisons are also accounted for.

((DATETIME_DIFF({End (from Roadmap)}, {M's End Date copy})))) /This is trying to compare the second set of dates in two columns

If the first or second condition is true i.e the dates don't match I need it to return a value of say 1.

Can someone help correct this for me ?

[kuovonne]

IF(

  OR(

    NOT(IS_SAME(

      {Start (from Roadmap)},

      {M's Start Date},

      "day"

    )),

    NOT(IS_SAME(

      {End (from Roadmap)},

      {M's End Date copy},

      "day"

    ))
  ),

  "Dates do not match"

)

[Taskmaster]

OMG ! Thank you so much !! You are amazing