Trim a date

[EvansB2]

Hi there,

I have a long list of dates as presented in cell A1 below and would like to 'trim' it to only show the year in cell B1. Any assistance would be gratefully received as the list is very long!

Regards

Ben

[TABLE="width: 182"]
<colgroup><col width="35" style="width: 26pt; mso-width-source: userset; mso-width-alt: 1280;"> <col width="105" style="width: 79pt; mso-width-source: userset; mso-width-alt: 3840;"> <col width="103" style="width: 77pt; mso-width-source: userset; mso-width-alt: 3766;"> <tbody>[TR]
[TD="class: xl65, width: 35, bgcolor: #D9D9D9"] [/TD]
[TD="class: xl68, width: 105, bgcolor: #D9D9D9"]A[/TD]
[TD="class: xl69, width: 103, bgcolor: #D9D9D9"]B[/TD]
[/TR]
[TR]
[TD="class: xl66, bgcolor: #D9D9D9"]1[/TD]
[TD="class: xl70, bgcolor: transparent"]01-04-2002[/TD]
[TD="class: xl64, bgcolor: transparent"] [/TD]
[/TR]
[TR]
[TD="class: xl67, bgcolor: #D9D9D9"]2[/TD]
[TD="class: xl64, bgcolor: transparent"] [/TD]
[TD="class: xl64, bgcolor: transparent"] [/TD]
[/TR]
</tbody>[/TABLE]

 

[BarryL]

try:

=YEAR(A1)

 

[EvansB2]

Thanks. I did try that, however, when I got your reply I then realised that the data was not in number format as so I got a "#N/A"

Ben

 

[BarryL]

surely should be in date format no? try the below instead...

=RIGHT(TRIM(A1),4)

 

[BarryL]

might have to be the below actually

=RIGHT(TEXT(A1,"dd-mm-yyyy"),4)

 

[EvansB2]

Sorry, I mean the data was downloaded from a web site in excel and needed formatting.