Trim Dates

EvansB2

Board Regular
Joined
Nov 25, 2008
Messages
221
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,

AB
101/04/2019Apr-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
 

Some videos you may like

Excel Facts

What does custom number format of ;;; mean?
Three semi-colons will hide the value in the cell. Although most people use white font instead.

tyija1995

Well-known Member
Joined
Feb 26, 2019
Messages
747
Office Version
365
Platform
Windows
Hey,

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

DanteAmor

Well-known Member
Joined
Dec 3, 2018
Messages
10,213
Office Version
2007
Platform
Windows
You can have the date in B1 with the formula =A1, but in the format of the cell it changes to "mmm-yy"
 

Watch MrExcel Video

Forum statistics

Threads
1,089,739
Messages
5,410,156
Members
403,299
Latest member
Chards

This Week's Hot Topics

Top