Forum Discussion
Excel formula
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. The Original formula in column C is EOMonth(b3,36) column A...
As variant that could be
with
="Next review during " & TEXT( EOMONTH(B5,36), "mmm yyyy")which returns text which indicated during which month next review shall be done. If you need date, not text, EOMONTH(E5, 36) returns end of month in 3 years from release date. If you need exactly 3 years from release date it is =EDATE(B5,36).