I have a date like this: 23/05/2005 15:59:43. I need a formula to extract the
year - I've been trying mid, right, etc, but just can't get it. Thanks!
maryj
I have a date like this: 23/05/2005 15:59:43. I need a formula to extract the
year - I've been trying mid, right, etc, but just can't get it. Thanks!
maryj
=YEAR(date_cell)
--
HTH
RP
(remove nothere from the email address if mailing direct)
"maryj" <[email protected]> wrote in message
news:[email protected]...
> I have a date like this: 23/05/2005 15:59:43. I need a formula to extract
the
> year - I've been trying mid, right, etc, but just can't get it. Thanks!
>
> maryj
Hi
with date in A1
=YEAR(A1)
--
Arvi Laanemets
( My real mail address: arvil<at>tarkon.ee )
"maryj" <[email protected]> wrote in message
news:[email protected]...
>I have a date like this: 23/05/2005 15:59:43. I need a formula to extract
>the
> year - I've been trying mid, right, etc, but just can't get it. Thanks!
>
> maryj
Is the entry really a date or a string? If a date, then =year(a1) will get
the year. If a string, =MID(A1,FIND(" ",A1)-4,4).
"maryj" wrote:
> I have a date like this: 23/05/2005 15:59:43. I need a formula to extract the
> year - I've been trying mid, right, etc, but just can't get it. Thanks!
>
> maryj
That did it! I was trying to do a search based on the /, didn't think of
using the space!!
--
maryj
"bpeltzer" wrote:
> Is the entry really a date or a string? If a date, then =year(a1) will get
> the year. If a string, =MID(A1,FIND(" ",A1)-4,4).
>
> "maryj" wrote:
>
> > I have a date like this: 23/05/2005 15:59:43. I need a formula to extract the
> > year - I've been trying mid, right, etc, but just can't get it. Thanks!
> >
> > maryj
=YEAR(cell)
--
Regards,
Peo Sjoblom
"maryj" <[email protected]> wrote in message
news:[email protected]...
> I have a date like this: 23/05/2005 15:59:43. I need a formula to extract
the
> year - I've been trying mid, right, etc, but just can't get it. Thanks!
>
> maryj
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks