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 ...
- BINGO! Thanks Hans.
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.
- BINGO! Thanks Hans.