Add "x" years to date when it has certain words
Closed
TheAnalyst
-
9 Jun 2016 à 15:10
RayH Posts 122 Registration date Tuesday 31 August 2010 Status Contributor Last seen 20 June 2016 - 11 Jun 2016 à 10:56
RayH Posts 122 Registration date Tuesday 31 August 2010 Status Contributor Last seen 20 June 2016 - 11 Jun 2016 à 10:56
Related:
- Add "x" years to date when it has certain words
- 2007 microsoft office add-in microsoft save as pdf or xps - Download - Other
- Excel add days to date - Guide
- How to add at the rate in laptop - Guide
- How to add authorized user t mobile - Guide
- How to add keywords to youtube channel - Guide
1 response
OK, so the format (syntax) for If as as follows:
=IF(LOGIC_TEST,TRUE,FALSE)
With that being said, you can nest IF statements, as in:
=IF(LOGIC_TEST_1,IF(LOGIC_TEST_2,TRUE_FOR2,FALSE_FOR2)
,FALSE_FOR1)
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.
So 365*5=1825
But in that period there is a leap year, with a leap day, so we must add 1.
So 1825+1=1826
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!
See Below:
=IF(LOGIC_TEST,TRUE,FALSE)
With that being said, you can nest IF statements, as in:
=IF(LOGIC_TEST_1,IF(LOGIC_TEST_2,TRUE_FOR2,FALSE_FOR2)
,FALSE_FOR1)
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.
So 365*5=1825
But in that period there is a leap year, with a leap day, so we must add 1.
So 1825+1=1826
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!
See Below:
9 Jun 2016 à 21:02
For 5 years:
For 10 years:
So, to add 5 years to a date when a cell contains a "word":
10 Jun 2016 à 22:08
Hopefully this is a lesson for all of those looking for this type of solution!
Don't be surprised when it doesn't work!
11 Jun 2016 à 10:56