Hi,
I encountered two problems here while dealing with date (eg. 31/1/2018).
1. I tried to use RIGHT function to extract the year, =right(the cell, 4), and I get 3111 instead of 2018.
2. As the 1 in the middle means January, I hope to extract "1" from there, is there any function could do so?
Any help would be much appreciated. Thanks!
3111.PNG
Bookmarks