Excel: Calculate next future date


Given:

=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 01, 2017.


For more resources for Microsoft Excel