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,

[TABLE="width: 143"]
<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>[TR]
[TD="width: 29, bgcolor: transparent"] [/TD]
[TD="width: 79, bgcolor: #D9D9D9"]A[/TD]
[TD="width: 82, bgcolor: #D9D9D9"]B[/TD]
[/TR]
[TR]
[TD="bgcolor: #D9D9D9"]1[/TD]
[TD="bgcolor: transparent"]01/04/2019[/TD]
[TD="bgcolor: transparent"]Apr-19[/TD]
[/TR]
[TR]
[TD="bgcolor: #D9D9D9"]2[/TD]
[TD="bgcolor: transparent"] [/TD]
[TD="bgcolor: transparent"] [/TD]
[/TR]
[TR]
[TD="bgcolor: #D9D9D9"]3[/TD]
[TD="bgcolor: transparent"] [/TD]
[TD="bgcolor: transparent"] [/TD]
[/TR]
[TR]
[TD="bgcolor: #D9D9D9"]4[/TD]
[TD="bgcolor: transparent"] [/TD]
[TD="bgcolor: transparent"] [/TD]
[/TR]
</tbody>[/TABLE]

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