Splitting Year from Dates

[Mollas]

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]

=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

 

[MyVeryOwnSelf]

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]

Thank you. It worked!

=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]

This worked too! Thank you.

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.