Converting Quarter to Date

Hi,

I need help for converting Quarter to date. Example: 3Q 2019 should show 09/30/2019.

Thanks!

1 way...
=--(INDEX({"1/1","4/1","7/1","10/1"},MATCH(N3,{"1q","2q","3q","4q"},0))&"/2019")
where N3 would contain your Q3

OR
create a small table with Q's and dates and use vlookup...

	N	O
3	1q	1/1/2019
4	2q	4/1/2019
5	3q	7/1/2019
6	4q	10/1/2019
7
8	2q	4/1/2019

Originally Posted by Phuocam

Or try:

=DATE(RIGHT(A1,4),LEFT(A1,1)*3+1,0)

ooops I forgot the Q included the year - thanks for (indirectly) pointing that out

Changes to my suggestion...
=--(INDEX({"1/1","4/1","7/1","10/1"},MATCH(LEFT(N8,2),{"1q","2q","3q","4q"},0))&"/2019")
or

	N	O
3	1q	1/1/2019
4	2q	4/1/2019
5	3q	7/1/2019
6	4q	10/1/2019
7
8	2q 2019	4/1/2019

Phuocam's suggest might be a better approach than mine