Using the YEAR formula to convert a DD/MM/YYYY column format to show YYYY in another column

Hi All,

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

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!