Table of Contents
To change the current year to a specific year in Google Sheets, follow these steps:
1. Select the cell where you want the specific year to appear.
2. In the formula bar, type “=DATE” and open parenthesis.
3. Enter the desired year in the first argument, followed by a comma.
4. Next, enter the number representing the month in the second argument, followed by a comma.
5. Finally, enter the number representing the day in the third argument, and close the parenthesis.
6. Press enter to see the specific year displayed in the selected cell.
By using the “DATE” function, you can easily change the current year to any specific year in Google Sheets.
YEAR
Returns the year specified by a given date.
Sample Usage
YEAR(DATE(1969,7,20))
YEAR(A2)
YEAR(40909)
Syntax
YEAR(date)
date– The date from which to calculate the year. Must be a cell reference to a cell containing a date, a function returning a date type, or a number.
Notes
Ensure that the input to the function is either a reference to a cell containing a date, a function which returns a date object such as
DATE,DATEVALUEorTO_DATE, or a date serial number of the type returned by theNfunction. Google Sheets represents dates and times as numbers; while conversion is automatic when a human-readable date is entered into a cell, functions only accept literal dates in numeric format.YEARdoes not autoconvert number formats in the same way that Google Sheets does upon direct entry into cells. Therefore,YEAR(10/10/2000)is interpreted asYEAR(0.005), the quotient of 10 divided by 10 divided by 2000.
See Also
WEEKDAY: Returns a number representing the day of the week of the date provided.
TO_DATE: Converts a provided number to a date.
N: Returns the argument provided as a number.
MONTH: Returns the month of the year a specific date falls in, in numeric format.
DAY: Returns the day of the month that a specific date falls on, in numeric format.
DATEVALUE: Converts a provided date string in a known format to a date value.
DATE: Converts a year, month, and day into a date.
Examples
Returns the year specified by a given date.
[wpcc-iframe height=”300″ src=”https://docs.google.com/spreadsheet/pub?key=0As3tAuweYU9QdFNvVF9KSE5ENmtvanczdmFZSzZTVmc&single=true&gid=0&output=html&widget=true” width=”500″]
Cite this article
stats writer (2024). How can I change the current year to a specific year in Google Sheets?. PSYCHOLOGICAL SCALES. Retrieved from https://scales.arabpsychology.com/stats/how-can-i-change-the-current-year-to-a-specific-year-in-google-sheets/
stats writer. "How can I change the current year to a specific year in Google Sheets?." PSYCHOLOGICAL SCALES, 28 Jun. 2024, https://scales.arabpsychology.com/stats/how-can-i-change-the-current-year-to-a-specific-year-in-google-sheets/.
stats writer. "How can I change the current year to a specific year in Google Sheets?." PSYCHOLOGICAL SCALES, 2024. https://scales.arabpsychology.com/stats/how-can-i-change-the-current-year-to-a-specific-year-in-google-sheets/.
stats writer (2024) 'How can I change the current year to a specific year in Google Sheets?', PSYCHOLOGICAL SCALES. Available at: https://scales.arabpsychology.com/stats/how-can-i-change-the-current-year-to-a-specific-year-in-google-sheets/.
[1] stats writer, "How can I change the current year to a specific year in Google Sheets?," PSYCHOLOGICAL SCALES, vol. X, no. Y, ص Z-Z, June, 2024.
stats writer. How can I change the current year to a specific year in Google Sheets?. PSYCHOLOGICAL SCALES. 2024;vol(issue):pages.