Question: how to make a year formula in excel?
Answer: YEAR is an inbuilt function in excel that can be used both as worksheet function and VBA function in excel. For Example, =YEAR (2018-11-25) would return the result as 2018. It does not matter whether the date is in date format or date & time format. YEAR can extract the year value from the supplied value.