How to add/subtract days and months to from another date.

[wonka1234]

Hi,

I want to incorporate the following logic into a new column

If [date] => "13th of the month of the [date] column" then [date] + 3months

if [date] < "13th of month of the [date] column" then [date] - 1 month\

[date] values look like so:

2021-11-03
2021-11-16

So with this said the new column should show:

2021-11-03       ->    2021-10-03 (-30 days or 1 month)
2021-11-16      ->    2022-02-16   (+90 days or 3 months)

Thanks,

Jonathan

[AmalinaH]

Hi @wonka1234 , you can utilise a formula like this:

if DateTimeDay([Date])<13 then DateTimeAdd([Date],-1,"months")
else DateTimeAdd([Date],3,"months")
endif

Hope that helps!

[Luke_C]

Hi @wonka1234 

Something like the below formula should work. I would note using days vs months in the datetimeadd function will yield different results based on how the formulas work. It looks like months gets you your expected results.