Question: how to calculate date in the future in excel?
Answer: The format is simple. It's just EDATE(start_date,months). For example, if the last invoice date (1/15/2012) is in cell B2 and you need to find the next quarterly billing date, you could use the formula =EDATE(B2,3). That will give you 4/15/2012, the date 3 months from 1/15/2012.