How would I add months to a date using formula?

wonsun

Hello,

So I'm having trouble adding different months to a certain date.

One column is a date, and the other column is when the duration of the offer

Date Offer exp.

2019-05-03 36 month

2018-03-27 12 month

2018-11-22 31 month

I'm trying to add an extra column using formula and think I should use a datetimeadd

but I'm having trouble filling in the formula. How should I do this? Help would be appreciated. Thanks

Date Time

Accepted answers

Jonathan-Sherman

Hi @wonsun,

You could use a text to columns to split your expiry details and use the DateTimeAdd() function:

If this solves your issue please mark the answer as correct, if not let me know! I've attached my workflow for you to download if needed.

Regards,

Jonathan

20200709 - AddingDynamicMonths.yxmd

grazitti_sapna

Hi @wonsun,

Here is another approach using only one formula tool. I hope it helps

Datetimeadd.yxmd

All comments

Jonathan-Sherman

Hi @wonsun,

You could use a text to columns to split your expiry details and use the DateTimeAdd() function:

If this solves your issue please mark the answer as correct, if not let me know! I've attached my workflow for you to download if needed.

Regards,

Jonathan

20200709 - AddingDynamicMonths.yxmd

ArtApa

DateTimeAdd (<date/time>, <interval>, "months") Return the given date/time extended by the given duration. The <interval> specified the amount of time to be added, and <units> the date/time units to add. The units are years, months, days, hours, minutes, or seconds (only one can be used), and the interval can be either positive or negative.

wwatson

Regards

grazitti_sapna

Hi @wonsun,

Here is another approach using only one formula tool. I hope it helps

Datetimeadd.yxmd

wonsun

Thank you so much! This helped a lot 🙂

spsanu

Thanks for this very helpful, Just wondering would it be possible to exclude last month , for example start date is Jan21 and month is 12 then as per this formula it would go till next Jan22, however, I would like to stop at Dec21 only, if I put -1 would that work or need to calculate the days differences as well.

Thanks,

Satya

Quick Links

This months top contributors

mceleavey 383

mbarone 337

Hollingsworth 335

LanisC 335

JeffF 335