Hi everyone,
Just followed the steps recommended by 'Mr. Excel' on how to deal with dates before 1900. It works perfectly well, except when the ended year date is 1900.
birth 20/07/1898
death 01/01/1900
birthmodified 20/07/2898 Formula =LEFT(C2,LEN(C2)-4)&RIGHT(C2,4)+1000
deathmodified #VALUE! Formula =LEFT(D2,LEN(D2)-4)&RIGHT(D2,4)+1000
Any ideas on how to sort this out are very welcome.
Thank you in advance, Mafy
Just followed the steps recommended by 'Mr. Excel' on how to deal with dates before 1900. It works perfectly well, except when the ended year date is 1900.
birth 20/07/1898
death 01/01/1900
birthmodified 20/07/2898 Formula =LEFT(C2,LEN(C2)-4)&RIGHT(C2,4)+1000
deathmodified #VALUE! Formula =LEFT(D2,LEN(D2)-4)&RIGHT(D2,4)+1000
Any ideas on how to sort this out are very welcome.
Thank you in advance, Mafy