
- Mark as New
- Bookmark
- Subscribe
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
Aug 03, 2021 10:10 AM
Hi guys,
I’m trying to find a way to insert a formula that calculates the expiration date of leases based on the commencement date and the number of months that the contract is for. So far, I have this:
DATEADD({Commencement}, {Term (mos)}, ‘months’)
This calculates the expiration date almost perfectly, but I need to find a way to take one day off of the formula. A 12 month lease starting on 03/01/21 would return 03/01/22, but the expiration would actually be the last day of February, not the first day of March, if that makes sense.
How can I get the formula to subtract one day from the result?
Thank you!
Solved! Go to Solution.
Accepted Solutions

- Mark as New
- Bookmark
- Subscribe
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
Aug 03, 2021 12:19 PM
Wrap it in another DATEADD()
function:
DATEADD(
DATEADD({Commencement}, {Term (mos)}, 'months'),
-1,
"days"
)

- Mark as New
- Bookmark
- Subscribe
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
Aug 03, 2021 12:19 PM
Wrap it in another DATEADD()
function:
DATEADD(
DATEADD({Commencement}, {Term (mos)}, 'months'),
-1,
"days"
)

- Mark as New
- Bookmark
- Subscribe
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
Aug 03, 2021 01:06 PM
Yes! Thank you! My brain could just not compute doing two functions together, I got so lost. I appreciate it!
