Date Calc Not Working

I feel like I am going crazy here....

I have a formula in the first column (formatted as a number) to take 04/27/22 and subtract 04/17/22 (both columns are formatted as date columns) but the result is 14? When I take the 04/17/22 and add that same cell of "14" I get 05/01/22.

Has anyone else run into similar issues when calculating date differences and what should I do to fix it? (I am doing a ton of calcs based off of dates in my sheet and now I am worried that they are wrong!

Xnip2021-10-06_13-16-25.jpg


Tags:

Best Answers

Answers

Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!