Date conversion issue

Hi,

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 date.now 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 ?

Rgrds
Aman

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