anything in Excel...

It's Excel-o-lozy...

Excel Formula to convert Date from to valid date format like YYYYMMDD to DDMMYYYY under formulaFix by Excelolozy.

www.Excelolozy.com - It's now easy to Convert YYYYMMDD to DDMMYYYY i.e. the Date from Raw text format to recognisable and valid Date format.

Following is the Formula :

formula is "ConvertDate"

=ConvertDate(Ref,OldFormat)


The formula "ConvertDate" is available within tool named "formulaFix".
 
"formulaFix" is a "Formula Fixing Tool" that provides various formulas that don't exist in Excel.
 
To download "formulaFix" click here.


Examples of formula "ConvertDate" are as follows :

Raw DateOld FormatFormulaConverted Date resultRemarks
20121013if omitted=convertdate(A2,)Saturday, October 13, 2012YYYYMMDD is taken by default if omitted in the formula.
13102012DDMMYYYY=convertdate(A3,B3)Saturday, October 13, 2012Any type of OLD FORMAT can be converted to any type of NEW FORMAT.
322012DMYYYY=convertdate(A4,B4)Friday, February 03, 2012
2313DMYY=convertdate(A5,B5)Saturday, March 02, 2013
2032013DMMYYYY=convertdate(A6,B6)Saturday, March 02, 2013
2013 03 2YYYY MM D=convertdate(A7,B7)Saturday, March 02, 2013
20130302YYYYMMDD=convertdate(A8,B8)Saturday, March 02, 2013
03-02-2013MM-DD-YYYY=convertdate(A9,B9)Saturday, March 02, 2013Any character of OLD FORMAT can be omitted by placing any character in NEW FORMAT.
13aaa3aaa02YYxxxMxxxDD=convertdate(A10,B10)Saturday, March 02, 2013
13bbb3bbb02YYxxxMxxxDD=convertdate(A11,B11)Saturday, March 02, 2013



To see practical application of above table do as follows :
1. Download formulaFix.
2. Copy paste above table (with headers) at any new excel workbook at cells range A1.

See the magic ;)

Anything in Excel, be an Excelolozian...
for best MS Excel Tips visit http://www.Excelolozy.com
gotta query??? drop a mail at mail@excelolozy.com