Function Type:
Date and Time
Description:
YEAR function in Excel or Google Sheets converts a serial number of a date to a day of the month.
It returns an integer from 1990 to future years.
You can use YEAR function to get the MONTH number from your TODAY function or NOW function which can be used in dashboards and summary sheets. As of this writing, you would get 2023.
I commonly use this YEAR function together with DAY function, MONTH function, and DATE function.
Function Structure:
=YEAR(serial_number)
Arguments
serial_number - this is the date or serial number representing a date
Examples
45258 in cell B7 is a serial number corresponding to November 28, 2023
Still need help with Excel and Google Sheets?
Get Instant Expert Help in Fiverr or PeoplePerHour platforms. Click one icon below.
We can also accept LEO, HIVE, HBD tokens as payment if we transact directly here in HIVE network.
This post is designated as a reviewer for Excel trainings I conduct.
Feel free to share with anyone. 😉
Earnings from Upvotes on this post are used to continue sharing Excel knowledge.
If you also want to earn HIVE in 7 days while blogging your favorite topics, join us here at Peakd.
*Thumbnail used is made in Canva