When is your date of birth?

Extract Dates from text using formulas


1.    =MID(B3,FIND(CHAR(47),B3)-2,10)
2.   =LOOKUP(9^9,MID(B4,ROW(INDIRECT(“1:”&LEN(B4)-9)),10)*1)
3.   =IFERROR(MID(B4,FIND("/",B4,1)-2,10),"No DOB present")
4.   =MID(B4,FIND("/",B4)-2,10)
5.   =IFERROR(MID(B4,MIN(IFERROR(FIND({0;1;2;3;4;5;6;7;8;9;”/”},B4),”")),10),”")

Comments

Popular posts from this blog

50 Excel VBA Oral Interview Questions