create new date column based on other column

[concrete]

Hi,

I have a column with dates when the last inspection was performed (e. g. 2022-01-12). Another column contains amount of days until the next inspection (e. g. 365, 730 and etc.). I would like to create a third column, which would show the date = last inspection date + days until the next inspection. Can someone help to achieve it? Thanks in advance.

Cheers,

Concrete

[amitchandak · Accepted solution]

@concrete , In date you can add days as the number

a new column

next inspection date = [last inspection date] + [days until the next inspection]