date conversion

function newbie · Dec 12, 2003

can a date be converted into the current year.
ie: cell a1 = 1/9/95 cell b2 should = 1/9/03

Peo Sjoblom · Dec 12, 2003

=DATE(YEAR(TODAY()),MONTH(A1),DAY(A1))

of course 02/29/00 will return 03/01/03

Dave R. · Dec 12, 2003

=+TEXT(MONTH(A1)&"/"&DAY(A1)&"/"&2003,"dd/mm/yy")

that appears to work..