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 | column B | Column C |
Document name | Release date | Next review date in 3 year time (mth-yyyy) |
Document management | 1/8/2025 | Aug 2028 |
4 Replies
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).
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")
