Data Conversion

italy16

New Member
Joined
May 9, 2014
Messages
29
Hello - thanks in advance for the help.

How do I convert the following "2019-Q3" which is formatted in excel as "General" to a date format so I can run a pivot table and be able to group by the date?

Thank you
 
Last edited:

Some videos you may like

Excel Facts

Which Excel functions can ignore hidden rows?
The SUBTOTAL and AGGREGATE functions ignore hidden rows. AGGREGATE can also exclude error cells and more.

jmacleary

Well-known Member
Joined
Oct 5, 2015
Messages
920
Office Version
2007
Platform
Windows
Hello. This will give you the first day of each quarter as an excel date value. (I have used L1 as the source cell don't ask me why!) -
Code:
=DATEVALUE(("01/"&TEXT(((MID(L1,7,1))-1)*3+1,"00")&"/"&LEFT(L1,4)))
 
Last edited:

Forum statistics

Threads
1,089,655
Messages
5,409,554
Members
403,270
Latest member
Man237

This Week's Hot Topics

Top