Forum Discussion
Sorting Dates which include some before 1900
I am sorting Ancestry information that includes Birth dates. The dates sort correctly if they are newer than 1900. The dates that are older than 1900 aren't sorted. Marriage and Death dates have the ...
Hi
For exemple, the dates are in A2:A6, 1 or -1 to choose order
=LAMBDA(Plage,Ordre,LET(date1,TEXT(Plage,"dd/mm/yyyy"),date2,TEXT(SORT((TEXTBEFORE(date1,"/",2)&"/"&TEXTAFTER(date1,"/",2)+5000)*1,,Ordre),"dd/mm/yyyy"),TEXTBEFORE(date2,"/",2)&"/"&TEXTAFTER(date2,"/",2)-5000))(A2:A6,-1)