change date texxt to date furmula

i got csv file date in text 2017/05/18. want convert date use use "today'sdate" less "dateincell" give me answer days ago.

a1 b1 c1

date csv today'sdate answer

18/05/2015 2017-12-12 01/07/26

if date in cell a1 of csv file stored 18/05/2015

assuming wish answer in cell c1 as

the difference of todays-date minus date in cell a1 - try following formula :

=today()-date(mid(a1,7,4)*1,mid(a1,4,2)*1,mid(a1,1,2)*1)

note: give answer in number of days , hence need format the

cell c1 either "general" or "numeric-without-decimals"

hope helps.

Office / Excel / Windows 10 / Office 365 Home

Cororate