excel - Date related query -

i stuck small issue in excel date function.

if given date ex. 15-02-2009 if need know equivalent of date of year, how find it?

for ex. given date 15-02-2009 ideally answer should 15-02-2016.

how calculate huge data?

many help!

best regards,

arun

i think easiest way is

=date(2016,month(a1),day(a1)) 

if original date in a1.