DATE FORMATTING from the 1600s

%3CLINGO-SUB%20id%3D%22lingo-sub-2891643%22%20slang%3D%22en-US%22%3EDATE%20FORMATTING%20from%20the%201600s%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-2891643%22%20slang%3D%22en-US%22%3E%3CP%3EHello!%26nbsp%3B%20I'm%20helping%20a%20friend%20who%20handles%20genealogy%20records%20for%20the%20entire%20island%20of%20Malta.%26nbsp%3B%20We%20have%20date%20conversion%20issues.%26nbsp%3B%20I%20learned%20how%20to%20reformat%20and%20strip%20cells%20of%20TEXT%20formatting.%26nbsp%3B%20The%20problem%20I%20am%20having%20is%20that%2C%20once%20I%20did%20get%20the%20formatting%20done%20the%20way%20that%20I%20need%20it%20(i.e.%2C%203%20Mar%201980)%2C%20when%20it%20comes%20to%20the%20very%20old%20records%20(i.e.%2C%205%20April%201683)%2C%20the%20efforts%20I%20made%20to%20amend%20the%20format%20stop%20working.%26nbsp%3B%20Is%20there%20a%20limitation%20on%20the%20date%20spread%20we%20are%20allowed%20to%20use%20on%20Excel%2C%20or%20is%20a%20date%20a%20date%3F%20Thank%20you%20so%20much!%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-2891643%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EExcel%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E%3CLINGO-SUB%20id%3D%22lingo-sub-2891678%22%20slang%3D%22en-US%22%3ERe%3A%20DATE%20FORMATTING%20from%20the%201600s%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-2891678%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F1197802%22%20target%3D%22_blank%22%3E%40BennieB%3C%2FA%3E%26nbsp%3B%3C%2FP%3E%0A%3CP%3EDate%20is%20sequential%20integer%20number%20where%201%20is%20Jan%2001%2C%201900%20(for%20Windows).%20Applying%20format%20you%20only%20show%20such%20number%20in%20user-friendly%20way.%20For%20the%20early%20dates%20there%20are%20some%20workarounds%2C%20but%20in%20any%20case%20these%20will%20be%20not%20dates%20in%20terms%20of%20Excel.%3C%2FP%3E%0A%3CP%3EPerhaps%20you%20may%20share%20small%20sample%20file%20to%20illustrate%20the%20question.%3C%2FP%3E%3C%2FLINGO-BODY%3E
Occasional Visitor

Hello!  I'm helping a friend who handles genealogy records for the entire island of Malta.  We have date conversion issues.  I learned how to reformat and strip cells of TEXT formatting.  The problem I am having is that, once I did get the formatting done the way that I need it (i.e., 3 Mar 1980), when it comes to the very old records (i.e., 5 April 1683), the efforts I made to amend the format stop working.  Is there a limitation on the date spread we are allowed to use on Excel, or is a date a date? Thank you so much!

2 Replies

@BennieB 

Date is sequential integer number where 1 is Jan 01, 1900 (for Windows). Applying format you only show such number in user-friendly way. For the early dates there are some workarounds, but in any case these will be not dates in terms of Excel.

Perhaps you may share small sample file to illustrate the question.

@BennieB 

HI Just joined looking for another subject but am interested in info from your data base. Great, great Grandfather was registered as born in Malta. Perhaps you could send me your link so I can give your more detail. rsaonmars@gmail.com thanks.