Forum Discussion
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 year time (mth-yyyy) |
| Document management | 1/8/2025 | Aug 2028 |
Question 1
I use formula using EOMonth(b3,36), it show 1/8/2028 and I dont know how to fix it to show only Aug 2028 ?
Question 2
my column B format cell is Date format. What date format should i set in column C ?
4 Replies
That's duplication of Excel formula | Microsoft Community Hub
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)
Right click on C3. ->Format Cells -> Custom ->Enter mmm yyyy in the type box. Click OK.
Can you not change the Cell Format Date MM-YYYY on coloum C:
