Subtracting Days from a Date



I am trying to subtract 30 days from a column pulling in dates from another sheet using formulas and it keeps yielding an #INVALID OPERATION error. I have already checked and do not have dependencies enabled. Both columns are formatted as date columns. While playing around I noticed when I add the days it instead tacks the number to the end of the year. How do I correct this?

Formula/function needed but causing error: =[Target Activation Date]@row - 30

Formula discovered just tacking number onto the end of the year instead of adding days: =[Target Activation Date]@row +30 (Picture for reference)



Best Answer


Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!