The ADDMONTHS function calculates the date that is some months after the given date.
addmonths(format, date, num_months) : date
The following example adds a column
x with a date that is 5 months later than the date in column
... | CALC x addmonths('dd/MM/yyyy', first, 5) | ...