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