Forum Discussion
Solved
Date Formula
This is probably a simple formula but I have not done it before. Therefore I am seeking some help.
Say I have a date in a cell in date format 6/24/21 or 2021
I wish to know what date it will be if you add 60 months or alternatively five years x 365 days = 1,825.
Trying to calculate the end date. Thank you.
- BINGO! Thanks Hans.
4 Replies
With a date in cell A1, the formula =EDATE(A1,60) will return the date 5 years = 60 months later.
- Thanks Hans. Kind of random - hundreds of cells calculated properly with this formula, but about five returned a non-date five digit number and they all started with 4? I can manually fix the five, but just wandering what might have gone off kilter? Thanks again. Bob
Try formatting all the cells with the formula as a date. I bet you'll see the expected result.
