Date conversion issue


I have to take out a column which is date actually but in excel it will be in string format.
that need to convert into data and minus with and that minus between both date should reflect in message box.

How to do it? can any one help i m stuck to convert that excel row from string to date ?

Hi Bharti,

Can you elaborate your question with an example ?


See this for conversion of string to date -

After this you can manipulate the date by adding or removing number of days like date.AddDays or by comparing dates

See this