Re: Convert Dates to current year

Tech-Archive recommends: Speed Up your PC by fixing your registry

From: Peo Sjoblom (terre08_at_mvp.org)
Date: 03/02/04 

Date: Tue, 2 Mar 2004 15:46:39 -0500

=DATE(2003,MONTH(A1),DAY(A1)) 

-- 
Regards,
Peo Sjoblom
"Phyllis" <anonymous@discussions.microsoft.com> wrote in message
news:5b0b01c40095$d39019e0$a001280a@phx.gbl...
> Thank you, that worked great.  Now suppose I want the year
> to be 2003.
> >-----Original Message-----
> >=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" <anonymous@discussions.microsoft.com> wrote in
> message
> >news:59ec01c40090$f1252310$a401280a@phx.gbl...
> >> 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?
> >
> >
> >.
> >
Quantcast