The date is saved as 01/01/1900 in Database. But when i pull a report and save it in excel the date 01/01/1900 changes to 02-Jan-1900 where it is suppose to be as 01-Jan-1900. But the other dates s per the database in report and excel. I m facing problem with this date 01-Jan-1900. Please help me to resolve it through macro.