kumara_faith
Well-known Member
- Joined
- Aug 19, 2006
- Messages
- 922
- Office Version
- 365
Hi,
I have a time stamp as follows in one cell.
9/4/2021 12:49:39 PM
Is there a way to extract the year from this cell ? When I use YEAR formula it returns as 13/7/1905. Appreciate all the help.
I have a time stamp as follows in one cell.
9/4/2021 12:49:39 PM
Is there a way to extract the year from this cell ? When I use YEAR formula it returns as 13/7/1905. Appreciate all the help.