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:

jmacleary

Well-known Member
Joined
Oct 5, 2015
Messages
727
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,078,211
Messages
5,338,888
Members
399,265
Latest member
aj17x55

Some videos you may like

This Week's Hot Topics

Top