Excel Date format

I have a excel with 2 sheets. I have to concatenate 3 columns of each sheet and vlookup the column SRno from sheet 1 to sheet 2.But the date formats are different in both the sheets.So i have to change the date format of both sheets and make it same. Is there any method to do that?
Screenshot 2022-11-25 114752

Hi @Amruta_George1

You can sue this if you want to format on excel

Range can be A:A for full a column

If you are reading it into datatable then

Datetime.ParseExact(“Date”,“Format for the given date(MM.dd.yyyy)”,System.Globalization.CulturalInfo.InvariantCulture)

Then use .ToString(“MM/dd/yyyy”) to get all dates in same format


I have used Datetime.parseExtract but thats not working

Hi @Amruta_George1

May I know how you used it

Can you share the workflow or the screenshots?

If you are writing vlook up on excel directly then please use the date format option that I showed in the previous post that will format your excel column as required


I have read the excel and 1st assigned it into a string variable as currentrow(“Date”).tostring and in 2nd assign varibale i have given euqtion as Datetime.parseexact(Date,“M/dd/yyyy”,nothing).tostring(“MM/dd/yyyy”)

Hi @Amruta_George1

First print the dates and check in which format they are

and if the dates are like MM/dd/yyyy(firstdate) and MM.dd.yyyy(SecondDate)

then use like this

This will give true if matched

Mostly from excel you might get hours minutes and seconds as well then include hh:mm:ss as well in the initial format