How to add a certain number of days to 'Date' type column and return a date?

Hi,
I have a ‘date’ type column called [LMP]. I am trying to add 9 months and 7 days to the date in LMP column and return the resulting date to another column called [EDD]. Is it possible to do this? Since different months have a different number of days, what I want is for the app to figure out which month the LMP column has and based on that month, add 9 months and 7 days to that and bring out the date for the [EDD] column. Would appreciate your help on this.

Thanks.

0 10 802
10 REPLIES 10
Top Labels in this Space