Add "x" years to date when it has certain words [Closed]
- Registration date
- Tuesday August 31, 2010
- Last seen
- June 20, 2016
OK, so the format (syntax) for If as as follows:
With that being said, you can nest IF statements, as in:
Date are no different than any other math with EXCEL! With that understanding, we can do something like:
We know that there are 365 Days in a year, and we want the number of days in a year.
But in that period there is a leap year, with a leap day, so we must add 1.
What about the periods of time when you get two Leap years, for 2 leap days? It is possible to have a leap year in year one, and a leap year in year 5, as leap years are 4 years apart!
Anyway, I guess I am really asking how accurate do you want this solution? If you take the time to learn about year functions, Excel will do this for you.
But for this example, we are going to then add 1826 to our cell, to get a maturity date!