Using the YEAR formula to convert a DD/MM/YYYY column format to show YYYY in another column
I am trying to create a formula to take the date column (DD/MM/YYYY) called "travel in date" and convert it over to YYYY in another column called "Year".
However, the following formula =YEAR([Travel In Date]16), it is converting over but showing the value incorrectly as 2022 when the date in the referenced cell is in 2023.
Any ideas on how to fix this or potential reasons this could be happening?
Help Article Resources
Check out the Formula Handbook template!