The =YEAR function returns the year corresponding to a date. The year is returned as an integer in the range 1900-9999. For example if cell A1 = 04/05/2020 then =YEAR(A1) would retun 2020 B7 = 01/02/2007 then =YEAR(B7) would return 2007 #excelwithdave #excel #learnexcel

@excelwithdave Tested--Thank you