Excel YEAR Function | Excel One Minute Functions Explained

The YEAR function in Excel returns the year corresponding to a date. The year is returned as an integer in the range 1900-9999. For example, if you have invoice dates or dates of hire with a format of M/D/Y in column B starting in cell B2, you can get the year by adding a column and using the formula =YEAR(B2).

Chapters:
0:00 Intro
0:17 Year function
1:07 Pivot Table with Year

Syntax
YEAR(serial_number)

The YEAR function syntax has the following arguments:
Serial_number - Required. The date of the year you want to find. Dates should be entered by using the DATE function, or as results of other formulas or functions. For example, use DATE(2008,5,23) for the 23rd day of May 2008. Problems can occur if dates are entered as text.

Excel playlist by Chris Menard
Excel one-minute video playlist https://www.youtube.com/playlist?list=PLsYjn_fAfG41-NEswWjtTnAW1OjliJf6u
Excel playlist - over 270 videos - https://www.youtube.com/playlist?list=PLsYjn_fAfG42S1JmTFr7B5eTQRvm5w3sF

#chrismenard #excel #excelfunction #microsoftexcel

And make sure you subscribe to my channel!

-- EQUIPMENT USED ---------------------------------
○ My camera – https://amzn.to/3vdgF5E
○ Microphone - https://amzn.to/3gphDXh
○ Camera tripod – https://amzn.to/3veN6Rg
○ Studio lights - https://amzn.to/3vaxyy5
○ Dual monitor mount stand - https://amzn.to/3vbZSjJ
○ Web camera – https://amzn.to/2Tg75Sn
○ Shock mount - https://amzn.to/3g96FGj
○ Boom Arm - https://amzn.to/3g8cNi6

-- SOFTWARE USED ---------------------------------
○ Screen recording – Camtasia – https://chrismenardtraining.com/camtasia
○ Screenshots – Snagit – https://chrismenardtraining.com/snagit
○ YouTube keyword search – TubeBuddy – https://www.tubebuddy.com/chrismenard

DISCLAIMER: Links included in this description might be affiliate links. If you purchase a product or service with the links I provide, I may receive a small commission. There is no additional charge to you! Thank you for supporting my channel, so I can continue to provide you with free content each week!