Add renewal date for subscription based sales

[Andy_Bowring]

Hi
I am a complete Novice with Airtable. I was once OK with Microsoft access but a long time time ago.

I have a website and I sell subscriptions which go up in the following increments
48hrs
1 month
3 month
6 month
12 months

In my orders table I have the date ordered field and other field called Item’s Name. This contains the following text 12 months Subscription, UK TV, Box Sets, This has been imported via a CSV and whilst it is showing as a single line text field the contacts are part of a url.

I am looking for a formula to create a renew date 1 month, 3 month hence etc please.

I hope all this makes sense. Any help appreciated please.
Andy

[JonathanBowen]

Hi @Andy_Bowring - this post is on a similar topic and you might be able to reuse some of the concepts in your base:

Concatenate formula fields with formatted date/time Formulas

Hi @Jessie_Jane - with a bit of tweaking I’m sure you can get the formula to work, but can I suggest an alternative approach? If I was designing this base, rather than have different columns for different subscription start and end dates, I would have one start and one end date and use another field to note the subscription. The problem with the method you have above is that as soon as you want to add another subscription duration, you need to add two new columns for the start and end date and …

It sounds like your subscription term is in the name (in a string of text). If this is the case, you could use FIND() to strip out the term into something useful, e.g.

IF(
  FIND('1 month', {Item}), 
  1,
  IF(
    FIND('3 month', {Item}), 
    3,
    ...
  )  
)

Then, once you have the subscription term, use the formula in the linked post to determine a renewal date.

---

If this answers your questions, please consider marking it as "solution". If not, please post again. Thanks!