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 the function as: =LEFT(C2,4)

I have also noticed that Excel does not acknowledge dates before 1900? Is there a way that I can format a column to acknowledge dates before that time? I am building a pretty decent sized project.

Thank you!

​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 the function as: =LEFT(C2,4) I have also noticed that Excel does not acknowledge dates before 1900? Is there a way that I can format a column to acknowledge dates before that time? I am building a pretty decent sized project. Thank you!  Read More

​