Having trouble returning valid dates

SASardy ✭✭✭✭
edited 01/26/24 in Formulas and Functions

I am trying to track dates that are reliant upon a variable field. When the variable field is "x", the return in the second column should be the original date plus 1 year and 1 day. When the field is not "x", the return should be the original date plus 2 years and 1 day (edit for clarity: the first column should just be the original date plus 1 day). The problem I am running into is with any date that falls on the 31st of the month, it returns an #INVALID VALUE. Below are screenshots of a few dates I put in to test along with my formula. Can anyone help me solve this???

Best Answer



Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!