Year Excel Formula




Excel Formulas > Date & Time Functions > YEAR

« Weekday | Year | Fv »

What is the use of Year formula?

Tells you the year from a given date


Syntax of Year formula:
year(of this date)

Examples of Excel Year formula:
year("12/31/1981") = 1981
year(today()) = current year

Buy Excel Formula E-book | Learn more about Excel Year Formula

More Date & Time Functions : Day | Hour | Minute | Month | Networkdays | Now | Second | Today | Weekday | Year

Mathematical Functions | Text Functions | Logical & Reference Functions
Date & Time Functions | Financial Functions | Information Functions

Microsoft Excel Formula Training - Ebook