Table of Contents
Google Sheets is a powerful spreadsheet program that allows for easy manipulation of data, including dates. One useful feature is the ability to add and subtract years to a date. This can be achieved by using the “DATE” function and specifying the desired number of years to add or subtract. By following a simple formula, users can effortlessly modify dates in their Google Sheets, allowing for more efficient data management and analysis. This feature is especially helpful for businesses and individuals who need to track and project future dates in their spreadsheets. With Google Sheets, adding and subtracting years to a date is a quick and straightforward process that enhances the functionality of the program.
Add & Subtract Years to Date in Google Sheets
You can use the following basic formulas to add and subtract years from a date in Google Sheets:
Formula 1: Add Years to Date
=EDATE(A1, 12*(3)) This particular formula adds 3 years to the date in cell A1.
Formula 2: Subtract Years from Date
=EDATE(A1, -12*(1)) This particular formula subtracts 1 year from the date in cell A1.
The following examples show how to use each formula in practice with the following dataset in Google Sheets:
Example 1: Add Years to Date in Google Sheets
We can type the following formula into cell C2 to add 3 years to the date in cell A2:
=EDATE(A2, 12*(3)) We can then drag and fill this formula down to each remaining cell in column C:
Column C now displays the date in column A with exactly 3 years added to it.
Feel free to change the 3 in the formula to any value you’d like to add a different number of years to the original date.
Example 2: Subtract Years from Date in Google Sheets
=EDATE(A2, -12*(1)) We can then drag and fill this formula down to each remaining cell in column C:
Column C now displays the date in column A with 1 year subtracted from it.
Feel free to change the 1 in the formula to any value you’d like to subtract a different number of years from the original date.
The following tutorials explain how to perform other common tasks in Google Sheets:
Cite this article
stats writer (2024). How can I add and subtract years to a date in Google Sheets?”. PSYCHOLOGICAL SCALES. Retrieved from https://scales.arabpsychology.com/stats/how-can-i-add-and-subtract-years-to-a-date-in-google-sheets/
stats writer. "How can I add and subtract years to a date in Google Sheets?”." PSYCHOLOGICAL SCALES, 27 Jun. 2024, https://scales.arabpsychology.com/stats/how-can-i-add-and-subtract-years-to-a-date-in-google-sheets/.
stats writer. "How can I add and subtract years to a date in Google Sheets?”." PSYCHOLOGICAL SCALES, 2024. https://scales.arabpsychology.com/stats/how-can-i-add-and-subtract-years-to-a-date-in-google-sheets/.
stats writer (2024) 'How can I add and subtract years to a date in Google Sheets?”', PSYCHOLOGICAL SCALES. Available at: https://scales.arabpsychology.com/stats/how-can-i-add-and-subtract-years-to-a-date-in-google-sheets/.
[1] stats writer, "How can I add and subtract years to a date in Google Sheets?”," PSYCHOLOGICAL SCALES, vol. X, no. Y, ص Z-Z, June, 2024.
stats writer. How can I add and subtract years to a date in Google Sheets?”. PSYCHOLOGICAL SCALES. 2024;vol(issue):pages.