Trying to check a box if 2 dates are within 14 days of eachother.

colbylomonaco ✭✭
edited 06/24/22 in Formulas and Functions

I tried this =IF([Datecolumn1]1 + 14 < [Datecolumn2], 1, 0)

but it just comes back as unparseable


Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!