Compare dates in the same row but different columns


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

Popular Tags:

Best Answer


Sign In or Register to comment.