Copy the formula in other cells using the keyboard shortcut keys Ctrl D. In the place of serial_number you have to select the cell that contains the date. September 1 2019 is a Sunday.
In the place of serial_number you have to select the cell that contains the date.
YEAR serial_number The YEAR function syntax has the following arguments. You now have your result. Apply IF with YEAR formula for remaining cells like I have shown in the below image. Copy the formula in other cells using the keyboard shortcut keys Ctrl D.