Splitting Year from Dates

M

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.
 
B

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
 
M

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.
Click to expand...

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.
 
M

Mollas

This worked too! Thank you.

MyVeryOwnSelf said:
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.
Click to expand...
 
Top