The Airtable Community will undergo scheduled maintenance on September 17 from 10:00 PM PST to 11:15 PM PST. During this period, you may experience temporary disruptions. We apologize for any inconvenience and appreciate your understanding.

# Re: Formula for calculating end date of license

3043 6
cancel
Showing results for
Did you mean:
6 - Interface Innovator

My sister can somehow calculate the value for the field `End date` in her head. Can someone please give me the formula that she is using, as I need to use a formula? :grinning_face_with_big_eyes:

https://airtable.com/shrWJArPUxWUy7HG2

18 Replies 18
6 - Interface Innovator

That’s basically how it’s setup in my “real” base. What I’m showing in here is just a small portion of it as it’s in Swedish :slightly_smiling_face: Creating a new record when a field hits a certain criteria was an interesting idea though! I’m trying to test it right now.

14 - Jupiter

No, you can’t use formulas, but you can enter the same date that occupies the “End Date” field of the record that triggered the automation:

6 - Interface Innovator

That’s a smart solution! Thanks! You don’t happen to know how to make the formula in my original question? :slightly_smiling_face: Kamille came close but the last date was wrong.

14 - Jupiter

I wouldn’t want to try to figure that out with a formula – which is why I made the suggestion I did. It’s definitely a challenge, and I’m sure @kuovonne could figure it out in little time. But it’s not how I would approach the problem, so I’m not terribly motivated to try and figure it out.

16 - Uranus

The example given didn’t add up correctly to begin with, unless there was some alternate reasoning why the renewal date for 2022-02-01 is 2023-11-01 (21 months) instead of 2024-02-01 (24 months) when the listed `{Length (months)}` value is 24, not 21.

The formula isn’t that complex when you break it down, I removed it because it appeared this was already being worked on by a consultant and I didn’t want to undercut their business by answering a redundant question for free.

6 - Interface Innovator

The example I gave you was wrong, your formula was right!

6 - Interface Innovator

I think your solutions might be better. I’m trying to set up an automation but I can’t get it to work: Test are OK but nothing happens when I turn on the automation. Can you see why?

16 - Uranus