convert month days and years into days

Originally Posted by optomyst

How are the cells that contain the date formatted? is it text with the date typed as shown?
If so, then you need to convert the text to dates as follows:
Under Data, select "Text to Columns"
Select Delimited then next
Select Tab then next
Select Date, MDY then Finish

Then you can simply subtract the two dates

Sir,

I followed your instructions and it convert the text into date format as expected, but when I subtract cell a2 to a1 it gives me the date, month and year. I want the result to be in number of days only.

thanks

Originally Posted by daddylonglegs

For the result in years, months and days try this formula

=DATEDIF(A1,B1,"y")&" years "&DATEDIF(A1,B1,"ym")&" months "&DATEDIF(A1,B1,"md")
&" days"

as suggested here

Sir,

This is exactly what I need but pardon me for not getting on how to use it. Could you pls give me an sample on excel sheet, I will just modify it.

thanks

just change the format of results column to number from date

Originally Posted by optomyst

just change the format of results column to number from date

Sir,

thanks, it does the trick.

God bless