Convert Dates to current year

  • Thread starter Thread starter Phyllis
  • Start date Start date
P

Phyllis

Okay, here's another question. I have a list of dates
that are mm/dd/yyyy. I want to convert each date to the
current year. For example: I want 10/1/1971 to become
10/1/2004. Is there a function or formula that will do
that for me?
 
=date(year(today()),month(a1),day(a1)

when the date is in A1

--

HTH

Bob Phillips
... looking out across Poole Harbour to the Purbecks
(remove nothere from the email address if mailing direct)
 
Phyllis

One way assuming dates in A2:A100

In B2 enter this formula

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

copy B2 down with the fill handle (the little square
in the lower right corner of the cell).
 
or even
=DATE(YEAR(TODAY())-1,MONTH(A1),DAY(A1))
if you want last year rather than 2003 specifically.

--

HTH

Bob Phillips
... looking out across Poole Harbour to the Purbecks
(remove nothere from the email address if mailing direct)
 
Thanks, you guys are awesome. I love this forum. It's
extremely helpful and informative. Thanks again.
 
Back
Top