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
Best Answer
-
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!
Answers
-
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!
-
Help Article Resources
Categories
Check out the Formula Handbook template!
