Date Maniplation

[satishkumar123]

Hi,


I want to find the difference in date from the below dates in the form yyyy-mm-dd


Eg:


Start date = 1980-02-22

End date = 1966-11-29


Result should be in yyyy-mm-dd format.


Pl.help.


Thanks

Satish.

 

[Debraj]

Hi Satish!


Welcome to the forum..


Manipulating DATE is very easy in EXCEL.. unless DATE is actually DATE not TEXT..

Can you please confirm the TYPE of the DATA..


* if your provided data is in A1, in B1 write formula as =TYPE(A1)

* then provide us the answer in NUMERIC.. (1/2)


Regards,

Deb

 

[NARAYANK991]

Hi Satish ,


Try this :


=TEXT(INT(DATEDIF(date1,date2,"y")/100),"00")&TEXT(date2-date1,"yy-mm-dd")


where date1 is 1966-11-29 , and date2 is 1980-02-22.


The result is a text string.


Narayan