Most valuable professional
  • Hot Topics

Excel Calculate next future date

Given: Code: =IF([@Start]>TODAY(),[@Start],DATE(YEAR([@Start]),MONTH([@Start])+[@Frequency],DAY([@Start]))) If Start=31/07/2016 and Frequency=12, the result is 31/07/2017. If Start=31/01/2016 and Frequency=12, the result is 31/01/2017. How can I adapt the formula so that the result is 31/01/2018 (the next date on or after today)?

This question generated 15 answers. To proceed to the answers, click here.

This thread is current as of April 1, 2017.

For more resources for Microsoft Excel:

This article includes the following tags:

  • Excel
  • Microsoft Excel