How to add one or more months to a date; how to add or substract one or more years to a date
Sometimes we need to add 1 or 2 months to a date or one year to a date. What is the best way to do this.
Some will say it is to add 31 days to the date or to add 365.25 days to one year. But this is not accurate as the months and years are not always the same.
= A1 + 365.25 (this would add about one year to the date but will not be exact)
Here is the trick.