SEARCH
Start Here
Learn
Excel Podcast
Listen to John Michaloudis interview various Excel experts & MVPs to get their inisghts & tips
Functions & Formulas
Learn how to use the Lookup, Text, Logical, Math, Date & Time, Array plus more functions & formulas
Pivot Tables
Learn Slicers, Pivot Charts, Calculated Fields/Items, Grouping, Filtering, Sorting, plus more
Macros & VBA
Learn how to automate your worksheet & reports with ready made VBA code
Power BI, Power Query & Power Pivot
Discover the new Business Inteligence & data visualization tools from Microsoft
Charts
Learn to create Smart Art, Column, Line, Pie, Bar, Area, Scatter, Bubble and Sparkline charts
Analysis
Learn Conditional Formatting, Data Validation, Excel Tables, Find & Select, Sort, Filter plus more
Shortcuts & Tips
Explore the various keyboard shortcuts & tips to make you more efficient in Excel
Webinars
Free Excel Masterclass
The 4 Step Framework to ADVANCE Your Excel Level within 30 DAYS!
Learn For FREE
Pivot Tables Webinar
Analyze tons of data with a couple of mouse clicks and create Excel Dashboards
Learn For FREE!
Functions & Formulas Webinar
Learn the must know Functions & Formulas: IF, SUMIF, VLOOKUP, INDEX/MATCH plus more
Learn For FREE!
Macros & VBA Webinar
Learn how to record Macros, write VBA code and automate your worksheet & reports
Learn For FREE!
Power Query
Quickly transform your data (without VLOOKUP) into awesome reports!
Learn For FREE!
Courses
Featured course:
MyExcelOnline Academy Online Course
Access a library of 1,000+ Microsoft Excel & Office video training tutorials, support & certification covering all levels and features like: Formulas, Macros, VBA, Pivot Tables, Power BI, Power Query, Power Pivot, Dashboards, Financial Modeling, Charts PLUS Microsoft Access, Word, PowerPoint, Outlook, OneNote, Teams, Power Apps, Power Automate, SQL, SharePoint, Project, Visio, Forms plus MORE!
JOIN NOW AND GET 60% OFF
Corporate Academy Online Course
Get your team skilled up in Excel and save with our corporate packages
See why leading organizations choose MyExcelOnline as their destination for employee learning
Academy Student Testimonials
Join 5,000+ Professionals Who Are Advancing Their Excel Skills In The MyExcelOnline Academy
Academy Members Login
If you are a current Academy member, click here to login & access this course
Books
Featured book:
101 Best Excel Tips And Tricks
Learn the BEST Microsoft Excel Tips & Tricks EVER, ranging from Formatting, Layout, Formulas, Tables, Pivot Tables, Working with Data plus Many More!
Buy NOW!
101 Most Popular Excel Formulas E-Book
Learn the most popular Excel Formulas ever: VLOOKUP, IF, SUMIF, INDEX/MATCH, COUNT, SUMPRODUCT plus more
101 Ready To Use Excel Macros E-Book
Access 101 Ready To Use Macros with VBA code which you can Copy & Paste to your workbooks straight away
101 Most Popular Excel Formulas Paperback on Amazon
Learn the most popular Excel Formulas ever: VLOOKUP, IF, SUMIF, INDEX/MATCH, COUNT, SUMPRODUCT plus more
101 Ready To Use Excel Macros Paperback on Amazon
Access 101 Ready To Use Macros with VBA code which you can Copy & Paste to your workbooks straight away
Consulting
Login
Search
FOLLOW ME
Facebook
Instagram
LinkedIn
Pinterest
Twitter
YouTube
DOWNLOAD OUR FREE 101 BEST
EXCEL TIPS & TRICKS E-BOOK!
FREE FORMULAS, VBA &
PIVOT TABLE COURSES. JOIN NOW!
LATEST POSTS
FORMULAS
Text
BETWEEN
CLEAN
CONCAT
EXACT
FIND
LEFT
LEN
LOWER
MID
PROPER
REPLACE
RIGHT
SEARCH
SUBSTITUTE
TEXTJOIN
TRIM
UPPER
VALUE
Date & Time
DATE
DATEDIF
DATEVALUE
DAY
DAYS
DAYS360
EOM
HOUR
MONTH
NETWORKDAYS
TODAY
WEEKDAY
WEEKNUM
WORKDAY
YEAR
Math
SUMPRODUCT
AVERAGE
COUNTIF
MOD
RAND
RANDARRAY
ROUND
SEQUENCE
SUBTOTAL
SUMIF
SUMIFS
RANDBETWEEN
OTHER MATH
Lookup
VLOOKUP
XLOOKUP
ADDRESS
CHOOSE
HLOOKUP
HYPERLINK
INDEX
INDIRECT
LOOKUP
MATCH
OFFSET
SUM
TRANSPOSE
Logical
AND
FILTER
IF
IFERROR
IFS
OR
SORT
SORTBY
SWITCH
UNIQUE
Statistical
LARGE
MAX
MAXIFS
MEDIAN
MIN
MINIFS
SMALL
Information
ISBLANK
ISERROR
ISNUMBER
ISTEXT
TYPE
Other (Formulas)
ARRAY
3D Formulas
Financial
TIP
PIVOT TABLES
Customize
Analysis
Group
Sort
Calculated Fields & Items
Filter
Slicers
Pivot Charts
Conditional Formatting
Other (Pivot Tables)
MACROS
Advanced Macros
Basic Macros
Chart Macros
Formula Macros
Highlighting Macros
Pivot Table Macros
Printing Macros
Workbook Macros
Worksheet Macros
Tips and Tricks
CHARTS
Smart Art
Column
Line
Pie
Bar
Area
Scatter
Bubble
Sparklines
Formatting Charts
Excel 2016 Charts
Infographic
POWER BI
Power Query
Power Pivot
ANALYSIS
Conditional Formatting
Data Validation in Excel
Excel Tables
Find & Select
Sort & Filter
Other (Analysis)
SHORTCUTS
Keyboard
Tips and Tricks
Add-ins
OFFICE 365
Access
Forms
OneDrive
OneNote
Outlook
Power Automate
PowerApps
PowerPoint
Project
Sway
Teams
Visio
Word
SEARCH
YEAR
This section shows the best articles about YEAR and how much you can do with it. Here are the top things you can do with YEAR:
Home
»
Excel Formulas
»
Date & Time
»
YEAR
YEAR Formula in Excel
March 12, 2019
Continue reading
Want to get better at Excel?
Join Our Excel Community
Get our Free Weekly Excel lesson plans that cover the must know Excel features and tips to make you better at Excel!
Subscribe Now
SEARCH EXCEL TUTORIALS
101 Excel Macros Examples
333 Excel Shortcuts for Windows and Mac
101 Excel Formulas & Functions Examples
101 Excel Pivot Tables Examples
Free Microsoft Excel Online Course – 20+ Hours Beginner to Advanced Course
Microsoft Excel Training | Free Excel Online Training Courses
How to Use Microsoft Teams
028: The Best Microsoft Excel Tips & Tricks in 2020!
11 Excel Data Entry Form Tips and Tricks
50 Things You Can Do With Excel Power Query
141 Free Excel Templates and Spreadsheets
Top 7 Excel Interview Questions to Land Your Dream Job!
