Splitting Year from Dates

  • Thread starter Thread starter Mollas
  • Start date Start date
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.
 
=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
 
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.
 
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...
 
Back
Top