Compare dates in the same row but different columns

Scott Rae

Hi all,

Im looking at counting the number of times two date columns differ within the same row

For example

Column 1 Column 2

11/2/20 11/2/20

11/4/20 14/11/20

11/3/20 11/3/20

25/5/20 12/6/20

In this data the answer i am looking for is 2 as row 2 and 4 both differ, whereas in row 1 and 3 the dates are the same in both columns

If anyone has had a similar issue and came up with a formula to do this that would be a great help

Many thanks

Chris Mondeau

Hi @Scott Rae ,

I used a helper column to check if the two dates are different, and if so, returned a value of 1. Then I used a sheet summary field to sum the "Different" helper column to get the total. Hope that helps a little!

Chris Mondeau

Hi @Scott Rae ,

I used a helper column to check if the two dates are different, and if so, returned a value of 1. Then I used a sheet summary field to sum the "Different" helper column to get the total. Hope that helps a little!

Scott Rae

@Chris Mondeau Fantastic,

That completely solved my problem.

Thanks so much :)