Forum Discussion
Using the LEFT Function on Date Formatted Cells
I have cells formatted to show the date as (ex. 1941-12-01), but when I use the LEFT function, I am stumbling onto a issue where it is dividing the year into 12. It is spitting out 1531 when I put t...
Thank you! I used =YEAR(.....) to cover all of the years after 1900. Then used =LEFT(......,4) to isolate any date before 1900 formatted as yyyy-mm-dd. After using =VALUE(.....) and then copy/pasting as values, I was able to isolate all years.
It took a while to manually retype the data, but since I manually inputted the data, a lesson was learned.
It took a while to manually retype the data, but since I manually inputted the data, a lesson was learned.
