How to Add or Subtract Years in Google Sheets
Learn how to move dates forward for backward by whole years.
Learn how to move dates forward for backward by whole years.
Learn how to use the DATEDIF function to find the number of years, months, or days between two dates.
The WEEKNUM function accepts a date and returns the week number (1 through 54) of that date. The date must be in a valid format, so you have to use the DATE function, wrap it in quotes, or use a cell reference to a date. If your days, months, and years are in different cells, … Read more