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" wrote in message
...
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

Hi

with date in A1
=YEAR(A1)


--
Arvi Laanemets
( My real mail address: arvil<attarkon.ee )


"maryj" wrote in message
...
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" wrote in message
...
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