ExcelBanter - How do I "extract" birthyear from a date field?

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

- Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)

- - How do I "extract" birthyear from a date field? (https://www.excelbanter.com/excel-discussion-misc-queries/58398-how-do-i-extract-birthyear-date-field.html)

How do I "extract" birthyear from a date field?

I have a column of birthdates in date format but need a column that contains
just the 2-digit birthyear, not the full date.

David Billigmeier

How do I "extract" birthyear from a date field?

=YEAR(A1)

--
Regards,
Dave

"cp" wrote:

I have a column of birthdates in date format but need a column that contains
just the 2-digit birthyear, not the full date.

salut

How do I "extract" birthyear from a date field?

That will show 4 digit year.
This would work
=TEXT(A1,"YY")

"David Billigmeier" wrote:

=YEAR(A1)

--
Regards,
Dave

"cp" wrote:

I have a column of birthdates in date format but need a column that contains
just the 2-digit birthyear, not the full date.

All times are GMT +1. The time now is 10:55 AM.