I am trying to create a formula to calculate the difference between two dates (year, month, and day)
The start date is 3/13/02 (E2) and the end date is 5/1/20 (G2). Here is my formula:
As you can see on the attached screenshot, it is returning 18 years, 1 month, 0 days.
According to my calculation, it should be 18 years, 1 month, 19 days including the end date.
Please help me figure out what I did incorrectly. I am not a techie, so if you could explain in easy-to-understand terms, I would greatly appreciate it.
@Cat09142020 your day calculation is subtracting G2 - …(G2) … (G2). .. or in another words you are getting 0 because you are subtracting it from itself.