Hi, I'm working on a spreadsheet with 15K entries. All have the year as dd-mm-yy. The column is formatted as text. Some of the years are 1800's which I'm not worried about as these are all in YYYY. All the other dates are from the 1900's. I tried using the formula =TEXT(DATE(1900+MOD(YEAR(G2),1000),MONTH(G2),DAY(G2)),"dd-mmm-yyyy"). This works fine up to about the 1950's when the year goes to the 2800's. Can someone help with a formula that will keep all the years in the 1900's.
Joyce
Joyce