Trim Dates

[EvansB2]

Hi there,

I would appreciate some help with this one. I would like to return in cell B1, the month and year based on the full date in cell A1,

	A	B
1	01/04/2019	Apr-19
2
3
4

<colgroup><col width="29" style="width: 22pt; mso-width-source: userset; mso-width-alt: 1060;"> <col width="79" style="width: 59pt; mso-width-source: userset; mso-width-alt: 2889;"> <col width="82" style="width: 62pt; mso-width-source: userset; mso-width-alt: 2998;"> <tbody> </tbody>

Regards

Ben

 

[tyija1995]

Hey,

In cell B1 enter the formula:
=TEXT(A1,"mmm-yy")

 

[DanteAmor]

You can have the date in B1 with the formula =A1, but in the format of the cell it changes to "mmm-yy"

 

[EvansB2]

Cheers. Does the job perfectly.

Ben