Google Sheets - Add or subtract days months or years to a date
https://www.prolificoaktree.com/google-sheets-add-or-subtract-days-months-or-years-to-a-date/
WebDec 28, 2017 · The formula to add the amounts in row 6 of the image is. =DATE (YEAR (B6)+C6,MONTH (B6)+D6,DAY (B6)+E6) This is going to take B6 and add the number of years, months, and days to it that are in this table. This adds a year but it also added 11 months and 27 days so it almost added two entire years. That’s why it’s 2018.
DA: 39 PA: 33 MOZ Rank: 68