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

Tags:

Best Answer

Answers

Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!