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..

Problem formatting dates from CSV file	2	Mar 9, 2014
Date/Time	1	Sep 30, 2010
date & Time	1	Nov 24, 2012
Converting from Decimal to Base-36 in Excel Formula	8	May 12, 2011
Date Formula 85 factor	7	May 31, 2010
How to extract a character from a string then VLOOKUP a table?	7	Jun 1, 2009
This should be easy, but can't find an answer...requesting your in	1	Jan 23, 2008
Summing Data by Date	5	Jun 24, 2009

Ask a Question