Question: how to calculate date in the future?
Answer: Select Add option from the Type section; Then click to select a cell that you want to calculate a future date based on; At last, enter the numbers of years, months, weeks or days that you want to add for the given date.