How To Use Excel Year Function

Using dates in financial modeling is very common and the year function helps extract a year number from a date into a cell.

How to use excel year function. You can use the year function to extract a year number from a date into a cell or to extract and feed a year value into another formula like the date function. The excel year function returns the year component of a date as a 4 digit number. Use the day function to extract a day number and use the month function to extract a month number. Converts a serial number to a year. It can be used as a worksheet function ws and a vba function vba in excel.

To calculate a year based on a date entered in some cell you use the excel year function exactly in the same way as we did in the previous example. As you can see from the above snapshot the year to date in column b. For example you can use the date function to create the dates january 1 1999 and june 1 2010 like this. Returns the serial number of the date before or after a specified number of workdays using parameters to indicate which and how many days are weekend days. The excel year function returns the year corresponding to date as a 4 digit number starting from 1900 until 9999.

Year can extract the year value from the supplied value. Add 10 years to date in another cell. As a worksheet function the year function can be entered as part of a formula in a cell of a worksheet. For example year 2018 11 25 would return the result as 2018. Get the year from a date.

Date year a2 10 month a2 day a2 the excel date function can also be used with other dates like to add time to an existing date. Where a2 is a cell containing the date. Use the year function to extract the year from a date into a cell. Copy the formula in other cells using the keyboard shortcut keys ctrl d. In this example we re wanting to see the date that s 10 years past an existing date.

A valid excel date as an argument to the function. The year function is an excel date time function that is used for calculating the year number from a given date. Year is an inbuilt function in excel that can be used both as worksheet function and vba function in excel. The date function creates a valid excel date using individual year month and day components. The formula returns the year from the dates.