ExcelBanter

ExcelBanter (https://www.excelbanter.com/)

- Excel Worksheet Functions (https://www.excelbanter.com/excel-worksheet-functions/)

- - List (https://www.excelbanter.com/excel-worksheet-functions/128312-list.html)

Arne Hegefors

List

Hi! I have a long list of dates in column A. IN col B I want to have only the
year of the date in column A. The date is written like: YYYY-MM-DD. How can I
get only the year? Thanks alot!

Roger Govier

List

Hi

In B1
=A1
FormatcellsNumberCustom yyyy
Copy down

or
=TEXT(A1,"yyyy")
and copy down

--
Regards

Roger Govier

"Arne Hegefors" wrote in
message ...
Hi! I have a long list of dates in column A. IN col B I want to have
only the
year of the date in column A. The date is written like: YYYY-MM-DD.
How can I
get only the year? Thanks alot!

All times are GMT +1. The time now is 05:22 AM.