Formula DATE

Options

 

Hi

I'm trying with the formula = DATE subtract months but I get #INVALID EJ: 05/18/2020 to 12/18/19, when I say that subtract 6 months I get an error but if the subtraction is within the same year the error does not come out, how should the formula apply?

Thank you

Tags:

Comments

Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!