ExcelBanter - Splitting Year from Dates

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

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

- - Splitting Year from Dates (https://www.excelbanter.com/excel-worksheet-functions/220478-splitting-year-dates.html)

Mollas

Splitting Year from Dates

Hello,

How do I split the year from a date. Example I will need to extract 2/23
and leave out 1978. The purpose is so that viewers can not reformat the text
to find out the year.

Bernard Liengme

Splitting Year from Dates

=MONTH(A1)&"/"&DAY(A1)
Then you could Copy & Paste Special - Values
but this will be text so no calculations are possible
or, Maybe Hide column A
best wishes
--
Bernard V Liengme
Microsoft Excel MVP
http://people.stfx.ca/bliengme
remove caps from email

"Mollas" wrote in message
...
Hello,

How do I split the year from a date. Example I will need to extract 2/23
and leave out 1978. The purpose is so that viewers can not reformat the
text
to find out the year.

MyVeryOwnSelf[_2_]

Splitting Year from Dates

How do I split the year from a date. Example I will need to extract
2/23 and leave out 1978. The purpose is so that viewers can not
reformat the text to find out the year.

If dates are in column A, one way is to put this in B1
=IF(ISBLANK(A1),"",TEXT(A1,"m/yy"))
and then copy down as far as needed.

Then select column B id use
Edit Copy
Edit Paste special Values

Then delete column A.

Mollas

Splitting Year from Dates

This worked too! Thank you.

"MyVeryOwnSelf" wrote:

How do I split the year from a date. Example I will need to extract
2/23 and leave out 1978. The purpose is so that viewers can not
reformat the text to find out the year.

If dates are in column A, one way is to put this in B1
=IF(ISBLANK(A1),"",TEXT(A1,"m/yy"))
and then copy down as far as needed.

Then select column B id use
Edit Copy
Edit Paste special Values

Then delete column A.

Mollas

Splitting Year from Dates

Thank you. It worked!

"Bernard Liengme" wrote:

=MONTH(A1)&"/"&DAY(A1)
Then you could Copy & Paste Special - Values
but this will be text so no calculations are possible
or, Maybe Hide column A
best wishes
--
Bernard V Liengme
Microsoft Excel MVP
http://people.stfx.ca/bliengme
remove caps from email

"Mollas" wrote in message
...
Hello,

How do I split the year from a date. Example I will need to extract 2/23
and leave out 1978. The purpose is so that viewers can not reformat the
text
to find out the year.

All times are GMT +1. The time now is 04:30 AM.