EDATE equivalent in Smartsheet - IFERROR(DATE(YEAR....

Tanya B

I found some examples in previous discussions and tried it

=IFERROR(DATE(YEAR([Sale Month]@row), MONTH([Sale Month]@row) + 1, DAY([Sale Month]@row)), DATE(YEAR([Sale Month]@row) + 1, 1, DAY([Sale Month]@row)))

my theory was if Dec 1 was +1, then Jan would be +2 etc….it seemed to work until Feb onwards it keeps returning Jan 2025??

dojones

I think your formula is returning as an error and then defaulting to Jan because this part of formula is hard coded to Jan.

DATE(YEAR([Sale Month]@row) + 1, 1, DAY([Sale Month]@row))

Maybe a simpler approach would be to just add 30, 60, or 90 days.

=[Sale Month]@row + 90