  Get instant live expert help with Excel or Google Sheets “My Excelchat expert helped me in less than 20 minutes, saving me what would have been 5 hours of work!”

#### Post your problem and you’ll get expert help in seconds.

Your message must be at least 40 characters
Our professional experts are available now. Your privacy is guaranteed.

# Excel YEAR Function – PENDING

Want to learn more about how to returns an integer representing the year of a supplied date using excel spreadsheet?? This post will give you an overview of how to returns an integer representing the year of a supplied date in excel.

## Syntax(Generic Formula)

`=YEAR(serial_number)`

• Serial_number [Required]: It is the date of the year that we want to find. By using DATE function, date enter.

## How the YEAR function Works

The YEAR function in Excel is a date & time function that is used for returns the year number from a given date. The function will return a four-digit year integer that is a year corresponding to a mentioned date. Figure 1: Example of returns the year corresponding to a date

To find the year corresponding to a date the YEAR you can use the function. In the example selected cell shown, the formula in D6 is:

`=YEAR(C6)`

The Excel YEAR function returns the year component of a date as a 4-digit number. In Excel YEAR function you can extract a year number from a date into a cell.

## More about Excel YEAR Function

• Excel can store in a serial number form.
• if the reference date is valid then It will only return year number
• You can extract only year number from given date which must be after 01-01-1900.
• It will return year in four digits.

### Did this post not answer your question? Get a solution from connecting with the expert. Another blog reader asked this question today on Excelchat:
Solution examples I have multiple columns on my spread sheet and want to switch from A-Z to Z-A based on values in column A
Solved by V. H. in 38 mins Concat formula is incorrectly formatting the date in column C. Currently column B has dd/mm/yyyy and I require mm/dd/yyyy
Solved by Z. Y. in 31 mins I need a formula that will allow me to calc before a certain date and after a certain date. =if(A2<=DATE(2015,8,27),(F2*1.14),(F2*1.15)) It just multiplies column F with 1.15. I'm assuming I need to bring in the date column into the equation?
Solved by M. Q. in 20 mins I need assistance setting up a time sheet formula where I can create a column of contiguous dates down the left hand side of the spread sheet. So I can copy a contiguous column of dates, rather than entering each date manually. I would only need to have work days in the list, ie Monday to Friday inc. with a couple of spare lines between each week.
Solved by Z. Y. in 40 mins Example: If a loan closes between October 1st & 15th, the first mortgage payment is due November 1st. If it closes between October 16th & 31st, the first payment is due December 1st.
Solved by S. S. in 15 mins ## Subscribe to Excelchat.co Another blog reader asked this question today on Excelchat: