December 31, 2017

Use Excel’s YEAR function to extract the year from a date

Happy new year! This is a good time to show Excel’s YEAR function. It extracts the current year from a date. It works whether you entered the date manually, if the date is the result of the =TODAY() or =NOW() functions, or if the date is a serial number, and it works regardless of formatting.

The syntax is:
=YEAR(date)

For example, if the value of A2 is 12/31/2017, the result of =YEAR(A2) is 2017.

To get up to speed quickly on other functions, check out my course, “Excel 2016 Formulas & Functions in 90 Minutes” at www.udemy.com/excel90min

Categories

Share:

Related Posts

Excel formula: convert Roman numerals to regular Arabic numbers

Last year, I did a TikTok video blog post about Excel’s =ROMAN function (watch it here). It will convert any regular Arabic number to Roman.

Microsoft removed the =COPILOT function from Excel

Microsoft will remove the experimental =COPILOT function from the Excel beta. They said they want functions to be more dependable and precise.

Now certified in AI Ethics

Just earned my third AI certification: AI+ Ethics, from AI Certs. Now offering training in ethics issues, including transparency, accountability, privacy, mitigating bias and compliance

AI chatbots helped researchers plot deadly attacks

From The Guardian: “Users posing as would-be school shooters find AI tools offer detailed advice on how to perpetrate violence. Tests of 10 chatbots carried

Earned another AI certification

I just earned the AI+ Executive certification from AI Certs. This is to assist and train companies in developing AI strategies, governance and risk management,