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

Nashaknik

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.

Carson Penticuff

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))

Carson Penticuff

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))

Nashaknik

Yes! That worked perfectly. Thank You!

Carson Penticuff

Happy to help!

vdemattei

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?

Carson Penticuff

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