Dates to Years

[cj21]

Hi

I need to convert a date to a year. My spreadsheet looks like the following:

A B
10-MAY-86 1986


I need a formula that creates column B. Is there one?


Thank you for your help

Chris

[Marcol]

Try this in B2

=YEAR(A2)

[cj21]

That's great thank you.

Chris

[NBVC]

If you are satisfied with the solution(s) provided, please mark your thread as Solved.

How to mark a thread Solved
Go to the first post
Click edit
Click Go Advanced
Just below the word Title you will see a dropdown with the word No prefix.
Change to Solved
Click Save