Trim Dates

EvansB2

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

DanteAmor

Well-known Member
Joined
Dec 3, 2018
Messages
7,881
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"
 

Forum statistics

Threads
1,078,337
Messages
5,339,632
Members
399,316
Latest member
LeroyWork

Some videos you may like

This Week's Hot Topics

Top