YEAR () support May 14, 2019 12:53 Updated In a formula type column, the YEAR () function is used to display the quarter number of a date type column. Formula YEAR(Column1) See tips. Example YEAR(Date) My Projet 1 will take place in 2018. My Projet 2 will take place in 2019. Related articles YEAR_MONTH () DAY () Formula QUARTER () SUBSTRACT () Comments 0 comments Please sign in to leave a comment.