Date populated from a start date then a number of months after it

Maxine Roberts

Hi everyone,

I'm after a formula that will take a date from the last time a process was completed and then add a number of months to it e.g. process was last completed 01/01/2021 and needs to be carried again 6 months later so the formula would populate the 01/06/2021

Devin Lee

Hey @Maxine Roberts

Give this a try

=IF(MONTH(Date@row) + 6 > 12, DATE(YEAR(Date@row) + 1, MONTH(Date@row) - 6, DAY(Date@row)), DATE(YEAR(Date@row), MONTH(Date@row) + 6, DAY(Date@row)))