Formula to match numbers in two different columns

Options

I have two columns with a date and a reference number. I also have another two columns with the same reference numbers (random order) but different dates. Please can someone help with a formula to find and match the two numbers then calculate the # of days between the two dates. Is that possible?

Jean

Best Answer

Answers

Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!