# Generate a date 48 months from "Delivered Date" and at the End of Month

Options

I am tracking vehicle leases for our company and I would like to have an "Expiration Date" auto generate 48 months later. The kicker is our leases always end at the end of the month so is there a formula that can generate that for me? I have been able to get the 48 months generated but there is not an EOMONTH function Smartsheet.

Tags:

• ✭✭✭✭✭✭
Options

There may be other solutions, but here is my approach:

=IF(ISDATE([Delivered Date]@row), IF(MONTH([Delivered Date]@row) = 12, DATE(YEAR([Delivered Date]@row) + 4, MONTH([Delivered Date]@row), 31), DATE(YEAR([Delivered Date]@row) + 4, MONTH([Delivered Date]@row) + 1, 1) - 1))

• ✭✭✭✭✭✭
Options

There may be other solutions, but here is my approach:

=IF(ISDATE([Delivered Date]@row), IF(MONTH([Delivered Date]@row) = 12, DATE(YEAR([Delivered Date]@row) + 4, MONTH([Delivered Date]@row), 31), DATE(YEAR([Delivered Date]@row) + 4, MONTH([Delivered Date]@row) + 1, 1) - 1))

• Options

Yes! That worked perfectly. Thank You!

• ✭✭✭✭✭✭
Options

Happy to help!

• ✭✭✭✭
Options

I'm trying to do this, but just adding a number of months to a date column. It seems like you've figured this out and was hoping to take it a step beyond that. Do you mind helping me add a number of dates to a date?

• ✭✭✭✭✭✭
Options

I can certainly take a look at it. You may want to start a new post to avoid any confusion.

## Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!