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...
Your question is not clear enough. Use EDATE() instead of EOMONTH().
=EDATE(B2,36)Can you please clarify about 36 or 48 months?
Hi Harun,
Please accept my sincere apology for mispresentation.
What formula string should I be using in column C so that I can monitor 36 or 48 month to auto calculate
the next review date
column A
column B
Column C
Document name
Release date
Next review date (mth-yyyy)
Remarks
Document management
1/8/2025
Aug 2028
This document need to be reviewed in 3 yearly
Document Approval
7/8/2025
Aug 2029
This document need to be reviewed in 4 yearly
I assume, you are looking for DATEDIF()
=DATEDIF(B2,C2,"Y") =DATEDIF(B2,C2,"M")
