Forum Discussion
Solved
formula in excel
Dear Experts, i want to insert a formula in column C to auto calculate the next review date as shown. column A column B Column C Document name Release date Next review date in 3 ...
Can you not change the Cell Format Date MM-YYYY on coloum C:
Hi Skandel590,
Thanks for the solution. How to revise the formula to become a string to calculate if the review year is not 36 months but can be 36 months or 48 months. Original formula EOMonth(b3,36)