Extracting year from a date column

Ask the Community Formulas
#1

Hello stackers,Actually I am managing a sheet for my students and I have one separate column for date of birth (DD-MM-YYYY) but I need to extract year out of it,Anyone know the exact formula for that

#2

You can use the following formula for this:

YEAR({Date Column})