When we try to import a date with the fomat yyyy-MM-DD , the cell contains a text , not a date. When we look your example for the importxml you can see the date is not formated correctly. If I import the same xml file us…...it is used after in excel formula. You will find attached the...Do you garanty the macro, formula in the sheet are working after...